Thread: Splitting cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albee Albee is offline
external usenet poster
 
Posts: 5
Default Splitting cells

I have a huge column of address info. All the info is only seperated by
spaces not comas. Each address is a different length so i cant even split by
using "spaces" because when seperated into seperate columns info does not
match (I.E. adress info straight down in one column, city or state in one
column). I need to have them seperated so I can do a mail merge. Can anyone
help me? Am i going to have to manually seperate each address by comas??