View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gerry.lisa@gmail.com is offline
external usenet poster
 
Posts: 31
Default separate text into multiple cells when there is ", "

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