If I have a cell with a string, like 123AB, is there a way I can use a macro to move the letters to the front of the string?
So does anyone know how to do this? The format is generally the same but could slightly vary.
Please Login or Register to view this content.
123AB
123A
12AB
1AB
etc.
But the end result does the same thing to each value.
AB123
A123
AB12
AB1
etc.
I appreciate your guys help.
Last edited by 111StepsAhead; 12-02-2011 at 12:35 PM.
Is a formula solution ok? ( see attached)
Or VBA:
Please Login or Register to view this content.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
This was the final solution. Thanks Domski for your time.
Please Login or Register to view this content.
Another approach:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks