separate text into different cells
 

I have text in an excel spreadsheet that I need to separate into different
cells. I don't know what function to use or how to set it up.
It is formatted like this in one cell:

City/State/Country

Thanks in advance for your help!

I'd select that column
then data|text to columns
delimited
by: /

(make sure that there are empty columns to the right)

yamareezy wrote:

I have text in an excel spreadsheet that I need to separate into different
cells. I don't know what function to use or how to set it up.
It is formatted like this in one cell:

City/State/Country

Thanks in advance for your help!

--

Dave Peterson

SUPERB! EXCELLENT! Thank you so much! You have made my day! Have a great
afternoon!

"Dave Peterson" wrote:

I'd select that column
then data|text to columns
delimited
by: /

(make sure that there are empty columns to the right)

yamareezy wrote:

I have text in an excel spreadsheet that I need to separate into different
cells. I don't know what function to use or how to set it up.
It is formatted like this in one cell:

City/State/Country

Thanks in advance for your help!

--

Dave Peterson