VBA to loop through contents of a cell

[iainfitzy]

Hi all,

I am looking for some help.

Effectively I have a cell that contains the following data :-

63303-9600
63303-5280
63303-9700

What I need to do is loop through this cell and take the first 10 characters and ouput to a row, then take the next 10 characters and output to the next row and so on until it has been through all the cell content.

Any suggestions.

Thanks,

Iain

[Norie]

Ian

Are the 3 values on separate lines within the cell?

If they are try this.

Please Login or Register  to view this content.