Hi,
I am trying to come up with a formula that extracts text before the first instance of any one of three symbols: period, hyphen, and forward slash.
So far I have the below formula which can only handle looking for one of the three symbols at a time.
=IF(AND((A2="Germany"),IFERROR(FIND("-",B2)>0,FALSE)),LEFT(B2,MIN(FIND("-",B2))-1))
What I need is a formula that will give me the output in column C of the image below.
Any assistance would be great.
Data.png
There's likely a better way but this should work
Please Login or Register to view this content.
Hi,
See if this does what you need:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Try this
Enter formula in C2 and copy down
Formula:
Please Login or Register to view this content.
v A B C 1 Employee location Employee id Output 2 Germany NYHJ-BW.7 NYHJ 3 Germany GEJ.AP-12 GEJ 4 Germany SPJ/LK-84 SPJ 5 Mexico POLSC/LK-7.SW 0
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks