Remove characters up to specific string and t

Closed
Maverick50 - Dec 13, 2009 at 11:54 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 14, 2009 at 08:26 PM
Hello,
In Office 2007 (Excell)
How can I remove characters up to specific string and the stop.

This is what I have:
Keller Road RV<br>19723 Keller Road<br>Foley, AL<br>Phone: (251) 955-6260

This is what I want:
19723 Keller Road<br>Foley, AL<br>Phone: (251) 955-6260

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 13, 2009 at 09:18 PM
use the formula

=RIGHT(A1,LEN(A1)-SEARCH(">",A1))

assuming the string is A1.

this finds out the first > in the original string
Thanks!! It worked like a charm. If I could contact you in the future I would appreciate it.
The worksheet is a POI file for camping. When it is completed I can upload it to my Garmin GPS.

Thanks Again!
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 14, 2009 at 08:26 PM
Preferably post your requirements in the newsgroup. somebody or other will help you.