• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Text Extraction

ExcelSur

Member
In C4 copied down:

=LEFT(B4,FIND(" (",B4)-1)

Hello Ali,
Your formula worked, but I have another issue. I just noticed that I have a few rows like this
J366 - ATOV(License & Onsite) (271)

and I want to remove just (271).

Thanks for your help
 

ExcelSur

Member
try =TRIM(LEFT(B4;SEARCH("%";SUBSTITUTE(B4;"(";"%";LEN(B4)-LEN(SUBSTITUTE(B4;"(";""))))-1))
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))
 

bosco_yip

Excel Ninja
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))
Hi,

pecoflyer's formula can work, just replace ";" to "," and formula become >>

=TRIM(LEFT(B4,SEARCH("%",SUBSTITUTE(B4,"(","%",LEN(B4)-LEN(SUBSTITUTE(B4,"(",""))))-1))

Remark :

For your information, in the countries like United States, Canada, Australia, United Kingdom, etc. functions are entered with arguments separated by commas ",". In other countries like Spain, France, Italy, Netherlands, Germany, functions are entered with semicolons ";".

Regards
Bosco
 
Last edited:
Top