Is there a way to pick street addresses out of cells, where no standard format exists. I am attaching an example. Thank you.
The password is "excelforum.com"
Is there a way to pick street addresses out of cells, where no standard format exists. I am attaching an example. Thank you.
The password is "excelforum.com"
Maybe I can delete everything up to the first number (address), and remove all headings (North East South West). Then will it be possible to remove everything after the word (street name) following the numbers (address)? I can lose the city and zip code if I have to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks