Hi Dil, i tried that, i got A in B1 and then when i dragged the formula that
i copied into B2 and got an a in B2, i then dragged it down and got a blank
in B3, i in B4, g in B5, r in B6, this then repeats itself over and over.

"DILipandey" wrote:

Hi Tix,

Use following logic / formula, supposing you have the data in cell A1:-
Enter following formula in B1:-

=MID(A1,1,1)

Enter following formula in B2 and drag the formula till end 600 rows or more
(per situation):-

=MID($A$1,FIND(B1,$A$1)+2,1)
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Tix" wrote:

Hi, i have a cell with approx 600 names in it seperated by a semi colon. I
want to get this data into rows, so one name per cell going down the page in
list form. Text to columns does that for columns, but Excel doesnt have
enough columns for that much data (otherwise i could do text to columns then
paste special and transpose to get it in a row).

Is there a similar command to text to columns that pastes the data from a
cell into rows rather than columns?