separate text into different cells

Y

yamareezy

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!
 
D

Dave Peterson

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

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

yamareezy

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