Need to Separate

  • Thread starter Thread starter Charles Reid
  • Start date Start date
C

Charles Reid

Hello All,

I was wondering if there is a way to separate the following:

I have the following:

TX;CA;NM;VT;NY;MI;OK;FL

I need it to be:

TX
CA
NM
VT
NY
MI
OK
FL

Thanks,

Charles
 
Data>Text to Columns>Delimited by ; will get it into columns.

Then copy>paste special>transpose will get it into one column.


Gord Dibben MS Excel MVP
 
Back
Top