I have a text string with multiple underscores "_". I want to remove the remaining text after that last underscore
Ex.
EKI_US_EN_ExcelForum_01132016_main1
EKI_US_EN_ExcelForum_01132015_homepage
Desired Output
EKI_US_EN_ExcelForum_01132016
EKI_US_EN_ExcelForum_01132015
Thanks!
Try below formula (considering your text is on cell A1):
=RIGHT(A1,LEN(A1)-FIND("^",SUBSTITUTE(A1,"_","^",LEN(A1)-LEN(SUBSTITUTE(A1,"_","")))))
With your sample data in A1:A2
These formulas return all of the left text up to the last underscore (but not including it)
These are the results:
Please Login or Register to view this content.
Is that something you can work with?
Or this
Formula:
Please Login or Register to view this content.
Data Range
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Ron/AlKey
Awesome. Thanks! This worked out well. Didn't realize it would be this complex. Good to know different functions to get the same result. Still trying to understand excels many functions.
Excelfandoo - your formula actually return the text string I wanted to remove. Definitely useful though.
- James
Last edited by jam_ran; 01-13-2016 at 12:22 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks