• 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.

Cell Content Extraction

C

claudia80

Member
Good morning.
I would like to extract from the contents of cells the content up to before the round bracket.

In this example: PALMA DI MONTECHIARO (AG)

the result is: PALMA DI MONTECHIARO

Thank you
 
what version of excel do you have
TEXTBEFORE() would be an option if using 365 excel version
=TEXTBEFORE(A1,"(")

OR
=LEFT(A1,SEARCH("(",A1,1)-1)
maybe include TRIM to remove spaces
=TRIM(TEXTBEFORE(A1,"("))
=TRIM(LEFT(A1,SEARCH("(",A1,1)-1))
 

Attachments

  • extract upto bracket - ETAF.xlsx
    9.2 KB · Views: 2
You must log in or register to reply here.
Back
Top