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)

What to you mean by "does not work". What happens when you try to sort?

Regards,
Fred

"Erik" wrote in message
...
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)