All thanks for your suggestions, time and help.
We are in a good enough state now.
Sent from my iPhone using Tapatalk
Type: Posts; User: BillyCasper
All thanks for your suggestions, time and help.
We are in a good enough state now.
Sent from my iPhone using Tapatalk
This was my first thought when originally explained to me as being a few hundred rows and then offering to help, a bit of text to columns, concatenation.....however it’s massive and random! Having...
Catch21 is kindly going to try and help out with a bit of VBA along the lines of identifying the suffix like Road or Street and then extracting to the left.
Not my DB, family, I wouldn’t tolerate...
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...