MrExcel Publishing
Your One Stop for Excel Tips & Solutions

String Manipulation


Posted by Mike Dalton on January 11, 2001 8:05 AM

Is there any way to take a 12 character string,
scramble the letters, and return a different string.
Example: Original String "ABCDEFGHIJKL"
Scramble & Return "ACBDLKGIJFEH"

Thanks


Posted by Michelle on January 11, 2001 11:49 AM

You can use the left, right and mid options. I don't know any way to randomly scramble them, but if there is a logic to your reorganization then the formula for what you have done above would be:
=left(cell,1)&mid(cell,3,1)&mid(cell,2,1)
and so forth