Forum Discussion
Solved
Name and Address on the same cell.
Hello, I need help please. I have a list of customer names and address in the same cell. How do I separate them. Tom
I'm in Europe, it was past midnight for me...
Perhaps this? Let's say you have the combined names/addresses in A2 and down.
In B2:
=LEFT(A2,MATCH(TRUE,ISNUMBER(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),0)-2)
In C2:
=RIGHT(A2,LEN(A2)-MATCH(TRUE,ISNUMBER(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),0)+1)
If you don't have Microsoft 365 or Office 2021, confirm both formulas by pressing Ctrl+Shift+Enter.
Then fill down.
The address could be split up further, into street, city and stat/zip
Thank you so much for sharing the excellent formular.
These days that could be like
=HSTACK( REGEXEXTRACT(A2:A100, "^.*(?=\s\d)"), REGEXEXTRACT(A2:A100, "(?=\d).*$") )
