VB Script help

[Joe_Fox]

Hope someone can help me here.

I need to write a bit of vb and don't know where to start really.
What I need to do is as follows:

I have a cell the has text on several rows within the cell, each row has been created using the ALT+Enter method of creating a carriage return.

So, in for example cell A5 the data is as follows:

	A	B	C	D	E
1					Red Blue Yellow Green

What I want the vb script to do is take each 'row' within the cell, and paste them to A6, A7, A8 (leaving 'Red' in cell A5) - a bit like using the 'Text to Columns' function but using the carriage return as the delimiter.

The result should be:

	A	B	C	D	E	F	G	H
1					Red	Blue	Yellow	Green

I tried using ALT+20 (carriage return I think) as the delimiter but couldn't get it to work.

Hope one (or two, or three!) of you can help me out here.

Cheers,
Joe

 

[Steven]

http://www.google.com/search?q=carr...gc.r_pw.&fp=44eb8ccc40613db6&biw=1189&bih=767

 

[Joe_Fox]

Steven, I have looked at many many pages on this and none have provided me with a result.
Trust me - I wouldn't come here asking this sort of question without googling around first.

Hope someone can help still.
Joe_Fox