separate text into multiple cells when there is ", "

[gerry.lisa]

I have address, city, province, postal code all in one cell (A1)

Can I split that into 4 cells containing address city
province postal code (A1-D1)

XL 2003

....Lisa

 

[T. Valko]

Use the Text to Columns feature.

Make sure cells B11 are empty. Any data in them will be overwritten.
Select cell A1
Gotot the menu Data>Text to Columns
Select Delimited>Next
Select Comma>Finish

Biff