Forum Discussion
Solved
Extract Text left of a character (that is after a certain portion of text)
Hi, I want to extract the first portion of text with special conditions. I want everything left of the underscore that is after the characters ORD. Here is an example: 19_Decline_Left Barrel...
Detlef,
As variant (without intermediate cells)
=IFERROR(LEFT(B3,SEARCH("_",B3,SEARCH("ORD",B3))),"")
Detlef,
As variant (without intermediate cells)
=IFERROR(LEFT(B3,SEARCH("_",B3,SEARCH("ORD",B3))),"")
Thanks Sergei.