• 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
Hello Experts
I am trying to extract text and exclude the brackets and the numbers in the bracket. I have attached a sample spreadsheet.

Thanks
 

Attachments

  • Chandoo Extract.xlsx
    9.3 KB · Views: 6
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
 
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))
 
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:
Oops sorry about that, Linux does not like the comma...
Just copy /Paste and replace the semi-colons with commas via Ctrl+H
 
Back
Top