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

Splitting cells
 

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

Splitting cells
 

Sure below is an example....

Here are Just a few examples of the hundreds of addresses i have in one
column...

61 Associates #12 Attn Bill Ritzel 350 Fifth Avenue Ste 3410 New York, NY
10118
A Highmark LLC C/O Marks Paneth & Shron LLP Attn Phyllis Jaffee 622 Third
Ave 7th Fl New York, NY 10017
A Paul Victor And Ellen G Victor T.I.C 50 East 79th Street Apt 15c New York,
NY 10021
A Paul Victor 50 E 79th Street Apt 15c New York, NY 10021
Aaa Garment Delivery Inc Pension Plan & Trust 242 West 36th Street New York,
NY 10018

I need the above info to be seperated into seperate columns so can do a
label mail merge.... It should be seperated into columns that are shown
below...

First name Last name Company Street Address City State ..... and so
on...

Does this help?? thank you for responding to the first post...


"Shane Devenshire" wrote:

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