Seperating Text from Numbers in a cell
the below only (sort of) works if the address has 5 characters for the street
and does not account for the number separation.
"Eduardo" wrote:
hi,
=LEFT(A1LEN(A1-5)
if this helps please click yes thanks
"MaryJ" wrote:
Hi, Column C has a bunch of addresses that have no spaces between the
number and street. (27smith lane instead of 27 smith lane). Is there
a way for me to quickly seperate the number and street name from the
preceding number in each cell of column c? There are 1075 cells in
column C. Thanks!
|