Thread: separate text into multiple cells when there is ", "
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default separate text into multiple cells when there is ", "
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 DataText to Columns
Select DelimitedNext
Select CommaFinish

Biff

wrote in message
ups.com...
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



Reply With QuoteReply With Quote