Can you help me with a formula to remove all characters including and after the "(" in Los Angeles (hollywood)?So my goal is to make Los Angeles (hollywood) --> Los Angeles
Can you help me do the same for Los Angeles (hollywood)? I need to remove everything including and after the "(" in "(hollywood)"So my goal is to make Los Angeles (hollywood) --> Los Angeles