Hi everyone,
Have real trouble with this one. Column B has a few thousand cells which contains numbers, letters and other characters. Some of these strings begin with 5 spaces, others begin with 10 spaces.
ie. ' SomethingSomethingSomething
ie.' Darkside
What I'm trying to do is write a macro which will go through column B, find any cells with strings that BEGIN with 5 spaces and move them over to the right 1 column. If the string BEGINS with 10 spaces, then move it over to the right 2 columns.
Any ideas?
Thanks!!
Bookmarks