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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing the contents of a cell based on another cell 9
Excel - Formula Query: Search for and Return Value 3
Getting a case sensitive match? 5
Excel Forumla to seach and return all values 7
Replacing a formula with the actual string or number 1
Formula/Function for Counting Characters in a cell 4
Seperating information in a cell 9
String formula conversion 1

Back
Top