Hi,
I have tons of adresses formatted in one cell like this: "Road of Liberty 14",
I need 1 cell for the adress and 1 for the house number
"Road of Liberty" "14".
The problem with splitting is that there are very often spaces in the adress, so Excel will split it the following way: "Road" "of" Liberty" "14"...
I couldn't figure out how to simply extract all numbers out of the text and paste it in the next cell.
Since it is a huge database and I will have to repeatedly do it again I would prefer not to do it manually.
Thanks in advance for any help !
Simon
Bookmarks