E
Erik
In trying to split addresses which contain both number and street in one
cell, I have extracted using these formulas: =REPLACE(B5,1,FIND("
",B5,1)-1,"") and this one: =LEFT(B5,FIND(" ",B5,1)-1). They yield a number
and a street in separate cells.
They work great but then trying to sort does not work. Help.
Erik (a Word 2007 user)
cell, I have extracted using these formulas: =REPLACE(B5,1,FIND("
",B5,1)-1,"") and this one: =LEFT(B5,FIND(" ",B5,1)-1). They yield a number
and a street in separate cells.
They work great but then trying to sort does not work. Help.
Erik (a Word 2007 user)