In C4 copied down:
=LEFT(B4,FIND(" (",B4)-1)
J366 - ATOV(License & Onsite) (271) |
try =TRIM(LEFT(B4;SEARCH("%";SUBSTITUTE(B4;"(";"%";LEN(B4)-LEN(SUBSTITUTE(B4;"(";""))))-1))
Hi,Hello pecoflyer,
I am getting an error when using this formula. Thanks for your response.
TRIM(LEFT(B4;SEARCH("%";SUBSTITUTE(B4;"(";"%";LEN(B4)-LEN(SUBSTITUTE(B4;"(";""))))-1))