Hi,

Show us some sample data and what you want it to look like afterwards.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Albee" wrote:

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