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