separate text into multiple cells when there is ", "

G

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

T. Valko

Use the Text to Columns feature.

Make sure cells B1:D1 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
 
Top