sorting data within a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to sort data in a cell by the name of the street.The cell lists the street numbers first then the street name.
Can I do this?
 
You can add a new column (e.g. Street) to the table, and use a formula
to extract the street. For example, with the addresses starting in cell
A2, enter the following formula in row 2 of the Street column:

=RIGHT(A2,LEN(A2)-SEARCH(" ",A2))

Copy the formula down to the last row of data, then sort on this column.
 
I tried the formula and it keeps saying there is an error, I'm sure I am doing something wrong
I added a new column to the left of the address so now D column is open and the street address is in E column. E1 is the first address and I entered this formula =RIGHT(E1,LEN(E1)-SEARCH("",E1)) what am I doing wrong?
 
You search for a null string, change "" to " "

--

Regards,

Peo Sjoblom

Lynn said:
I tried the formula and it keeps saying there is an error, I'm sure I am doing something wrong.
I added a new column to the left of the address so now D column is open
Click to expand...
and the street address is in E column. E1 is the first address and I
entered this formula =RIGHT(E1,LEN(E1)-SEARCH("",E1)) what am I doing
wrong?
 
Back
Top