Hello,
This is my first post here.
Hopefully the problem I'm having has a fairly simple solution !
Essentially we currently use the formula below to return the required text:
=LEFT(H2,FIND(":",H2)-1)
Cell H2 Contains: 165-3935: BOLT-HEX HEA
Text returned: 165-3935
However, due to a change in what our cells now contain the format is now:
Cell H2 now Contains: STRAP,CAT,261-6797
Desired Text to return: 261-6797
I am just unsure of the correct formula to return the desired text in the most simple way.
Please help and many thanks in advance !
smc4312
Bookmarks