I do not understand what any of that is but it worked so thanks very much :)

"Jarek Kujawa" wrote:

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 -