breakup address cell

[nottsfire]

Hello,

I have 2 columns generated by a database. Address & Postcode. The address column is comma deliminated.

I want to use this column in as the mail merge address but need to get each bit between commas on in a seperate cell. Looked at other posting on this site and I think i'm too inexperienced with excel to realise how to do it.

The cells look like this:
<TABLE style="WIDTH: 583pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=777 border=0 x:str><COLGROUP><COL style="WIDTH: 535pt; mso-width-source: userset; mso-width-alt: 26075" width=713><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 535pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=713 height=17>Address</TD><TD id=td_post_1522282 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent" width=64>postcode</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>BxxxxxxE HILLS PRIMARY SCHOOL,Mxxx LANE,BRAMCOTE,NOTTINGHAM,</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NG3 3GE</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>ExxxxxxxE PRIMARY SCHOOL,WHxxxxxxE GARDENS,TOP VALLEY,NOTTINGHAM,</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">NG3 3ED</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>KIxxxxxN SCHOOL,Lxxxx LANE,CARxxxxN IN LxxxxxxK,</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent">S83 3AW</TD></TR></TBODY></TABLE>

any ideas (addresses masked)
Thanks folks
nott-on-fire-at-the-moment

 

[VoG]

Insert some blank columns between the address column and the post code column. Then select the address column, Data > Text To Columns, follow the prompts, select Delimited and specify comma as the delimiter.

 

[DonkeyOte]

Have a look at using Text to Columns with Comma as delimiter, however, be sure to move Addresses to right of Post Codes (ie put Addresses in C with Post Codes in B) then highlight C and run text to Columns.

HTH

 

[nottsfire]

Oooooh,

Why is it when there is such a simple answer you feel duped into stupidity?

Thanks very much chaps.

Genius.

Notts-not-smouldering