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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 14, 2009 at 08:26 PM
Related:
- Remove characters up to specific string and t
- Characters in dinosaur game - Guide
- How to find specific words on a page - Guide
- Facebook special characters - Guide
- How to remove call barring in keypad mobile - Android Forum
- How to undo remove link on instagram bio - Instagram Forum
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
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
=RIGHT(A1,LEN(A1)-SEARCH(">",A1))
assuming the string is A1.
this finds out the first > in the original string
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 14, 2009 at 08:26 PM
Dec 14, 2009 at 08:26 PM
Preferably post your requirements in the newsgroup. somebody or other will help you.
Dec 14, 2009 at 08:55 AM
The worksheet is a POI file for camping. When it is completed I can upload it to my Garmin GPS.
Thanks Again!