Below is an example of data in a cell
111-333-222
I have tried several formulas in order to be able to substring everything from right until the first dash (first "-" from right).
In above case I would like to be able to only return "222".
Below is an example of data in a cell
111-333-222
I have tried several formulas in order to be able to substring everything from right until the first dash (first "-" from right).
In above case I would like to be able to only return "222".
assuming your data is in A1 and your data is always separated by "-" then in B1 copy paste below
=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",50)),50))
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Thanks! Works well!
you are welcome freddie !
if this resolves your query you can mark your thread as solved.(go through signature lines in post #2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks