Dear Excel Gurus,

From a spreadsheet of thousands of rows of address information,

I need to display a column with just the text street names,

My struggle is selecting the text street names as the data is unstructured. The text street names appear in different columns, sometimes with the numeric building numbers, sometimes not, sometimes with punctuation symbols, sometimes not.

Any tips? I’ve gone down MID function and post code (again fairly unstructured) look up routes but haven’t got far.

Thanks and regards.


Sent from my iPad using Tapatalk