Remove characters up to specific string and t

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
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!
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
Preferably post your requirements in the newsgroup. somebody or other will help you.