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!!