Sorting cells with a string formulas

  • Thread starter Thread starter Erik
  • Start date Start date
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)
 
What to you mean by "does not work". What happens when you try to sort?

Regards,
Fred
 
Back
Top