Right Function ?

[scoandr]

I have strings of data that include names and addresses. A hyphen separates the name and address. I'm trying to use a combo Find and Right function to extract just the address portion but it doesn't seem to be working. The addresses do vary in terms of the number of numeric characters. I have an example listed below. I'm using Excel 2002.

Stone & Knott - 29819 Sun Will
Doufourt - 10014 Heron Mdws
Doufourt - 10014 Heron Mdws

=RIGHT(F4,FIND("-",F4)-1)

Any assistance or suggestions would be greatly appreciated.

Thanks
Scott

 

[Norie]

Scott

Why not try Data>Text to columns... with - as a delimiter?

 

[jss1234]

Try this:

=trim(RIGHT(F4,LEN(F4)-FIND("-",F4,1)))

 

[scoandr]

wow, i feel foolish this morning. Made something easy more difficult then it needed to be. This worked perfect. Thanks.

Scott

 

[Scott Huish]

How about:

=REPLACE(F4,1,FIND("-",F4)+1,"")