G
Guest
Hi Everyone,
I have thousands of cells with names and addresses, and each cell combines
both. I'd like to separate "Jane Doe 123 Street Road" into "Jane Doe" in one
column then the rest of the address in another. I've tried text to columns
and the formulas =LEFT, =MID, etc None of these have worked because
everyone's name is a different number of characters. Any help is greatly
appreciated.
Thank you,
Aaron
I have thousands of cells with names and addresses, and each cell combines
both. I'd like to separate "Jane Doe 123 Street Road" into "Jane Doe" in one
column then the rest of the address in another. I've tried text to columns
and the formulas =LEFT, =MID, etc None of these have worked because
everyone's name is a different number of characters. Any help is greatly
appreciated.
Thank you,
Aaron