sorting data within a cell

[Lynn]

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?

 

[Debra Dalgleish]

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.

 

[Lynn]

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?

 

[Peo Sjoblom]

You search for a null string, change "" to " "

--

Regards,

Peo Sjoblom

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?