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??
|