Convert cell with commas to multiple cells

[LennyB]

Ihave a worksheet that shows a mailing address all in one cell (example: <TABLE style="WIDTH: 302pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=402><COLGROUP><COL style="WIDTH: 302pt; mso-width-source: userset; mso-width-alt: 14701" width=402><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 302pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=20 width=402>Po Box 4985, Ocala,3447. I want to expand this across three cells to enable use in mail merge. How can I make excel recognize the "commas"? Commas sometimes are followed by a space, sometimes not.
Using Excel 2007.
</TD></TR></TBODY></TABLE>

 

[Jonmo1]

Welcome to the board...

Try
Data
Text to columns
Deliminated
Comma

 

[VoG]

SElect the cells, Data > Text to Columns, check Delimited, click Next, check Space and Comma and Treat consecutive delimiters as one then click Finish.