Remove everything after (

Topic

New Reply

My brain is failing me this morning…

I was given a spreadsheet with rows of data where 1 cell has “Division Name (Division Owner)”

I need only the Division Name, but am drawing a blank on how to remove the (Division Owner)

Any guidance is GREATLY appreciated.

Reply | Quote

Replies

=LEFT(A1,FIND(“(“,A1)-1)
or use
=TRIM(LEFT(A1,FIND(“(“,A1)-1))
if there is a space before the (

Reply | Quote