separate text into different cells

[Guest]

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]

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

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

 

[Guest]

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