separating addresses into separate fields

[snipescc]

<TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=438 x:str=""><COLGROUP><COL style="WIDTH: 329pt" width=438><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="WIDTH: 329pt; HEIGHT: 12.75pt" class=xl63 height=17 width=438 align=left>I have a project at work that involves standardizing data sent to me from several different sources, in multiple formats. One of the places I get it from has all the information in one cell, and I need to separate it into different coulmns (one for first name, one for last name, one for street number, one for street name, one for zip code. There is a different number of words in the names, and a different number of words in the street names. This is a sample of what the data looks like. Remember, it is all in one cell. Can anyone help me? Is it possible to split the data into coulmns using a switch between letters and numbers as the delimiter?


</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" class=xl63 height=17 align=left></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17 align=left>Personal Information removed - Please only use sample data</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17 align=left></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="HEIGHT: 12.75pt" height=17 align=left></TD></TR></TBODY></TABLE>

 

[hiker95]

snipescc,

Welcome to the MrExcel forum.

See this link:
http://www.mrexcel.com/forum/showthread.php?t=491417

 

[snipescc]

Thank you for the help, some of those tricks are helping.

(By the way, the address data i posted had been altered, I changed the names and addresses, the town was the only part that was the same)