oopps, sorry misread yr post

presume your semicolon delimited data is in A1

then insert the following formulae:

B1: =LEFT(A1,FIND(";",A1)-1)
A2: =MID(A1,LEN(B1)+2,LEN(A1)-LEN(B1))
B2: =LEFT(A2,FIND(";",A2)-1)

then drag/copy down as needed

HIH




On 16 Kwi, 14:54, Jarek Kujawa wrote:
why not copy-PasteSpecial-Values, select Transpose to some other
location
apply text to columns
then come back with data in needed format
?





"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?- Ukryj cytowany tekst -

- Pokaż cytowany tekst -- Ukryj cytowany tekst -

- Pokaż cytowany tekst -