Sorting cells with a string formulas
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) |
Sorting cells with a string formulas
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) |
All times are GMT +1. The time now is 02:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com