Reply to thread

Message: [QUOTE="Ron Coderre, post: 3629623"] Actually, if the "J" is moved to the beginning of the string in C1, the formula can shrink even more, because the double minus signs are not necessary: Instead of (112 characters): C2: =MID($C$1,--MID(B2,1,1)+1,1)&MID($C$1,--MID(B2,2,1)+1,1)&MID($C$1,--MID(B2,3,1)+1,1)&MID($C$1,--MID(B2,4,1)+1,1) it could be this (104 characters): C2: =MID($C$1,MID(B2,1,1)+1,1)&MID($C$1,MID(B2,2,1)+1,1)&MID($C$1,MID(B2,3,1)+1,1)&MID($C$1,MID(B2,4,1)+1,1) Does that help? *********** Regards, Ron XL2002, WinXP-Pro [/QUOTE]