C claudia80 Member Apr 16, 2024 #1 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
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
ETAF Active Member Apr 16, 2024 #2 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
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))