How do I split a row of text into different columns according to number of characters using a macro? : I want to know if I can use a macro to separate data in a single column into different colums according to number of characters. For example, what I have is this in column A

A

AB

ABC

1A

564

8

What I need is this, in colums A, B and C

A AB ABC

8 1A 564

Thanks.