Forum Discussion
Left or trim function with IF
Is there a formula i can do save time avoid doing manually. I have List of codes which have numbers like following: J975 K414 J993 K206 J890.01 J977 K138 K174.01 What i am trying to do i...
Thank you thats brilliant.
How would you expand this as in if i had .0 or .1 or .00 in my list as well
How would you expand this as in if i had .0 or .1 or .00 in my list as well
This covers from ".00" to ".99":
=INDEX(SORT(SUBSTITUTE(A1,"."&TEXT(SEQUENCE(100,,0),"00"),"")),1)
A simplified formula may work, too:
=IFERROR(REPLACE(A1,FIND(".",A1),3,""),A1)
Also, if you have TEXTBEFORE/AFTER you might consider mtarler 's solution. You have a few options.
- Thanks guys
Really appreciate the help.