Seperating Text from Numbers in a cell
Well, that's even easier than a macro... And if needed, assuming the below
lookup formula is in A2:
=right(A1,len(a1)-len(A2)) will get you the street name in A3
"Teethless mama" wrote:
=LOOKUP(10^10,MID(A1,1,ROW(INDIRECT("1:"&LEN(A1))) )+0)
"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!
|