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 -