Remove characters up to specific string and t [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
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
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
Preferably post your requirements in the newsgroup. somebody or other will help you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!