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 for this, but what if there are codes with .02 ,.04 and 0.6 so all different kinds how would a formula remove all
That wasn't clear from your first post. Here's the revision:
=INDEX(SORT(SUBSTITUTE(A1,"."&TEXT(SEQUENCE(10),"00"),"")),1)- Thank you thats brilliant.
How would you expand this as in if i had .0 or .1 or .00 in my list as well
