ExcelBanter - Working with street addresses?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Working with street addresses? (https://www.excelbanter.com/excel-discussion-misc-queries/13400-working-street-addresses.html)

Sully

Working with street addresses?

How do I split the numbers from the text in a street address?

Peo Sjoblom

Datatext to columns, fixed delimiter
double click thos parsing indicators that you don't need

--

Regards,

Peo Sjoblom

"Sully" wrote in message
...
How do I split the numbers from the text in a street address?

All times are GMT +1. The time now is 05:17 PM.