Hello forum members,
This is my 1st post, first of all I want to say hello to everyone here
My problem is this:
I would like to extract, from the whole string the string that immediately precedes the parentheses
The cells contain several string separated by a carriage return – linefeed
my data looks something like this - I Need an Output like this
ELMS (United Autosports)
IMSA (Action Express) ------> ELMS IMSA
WRC (Hyundai) ------> WRC
WEC (Toyota)
Formula E (Renault)
Day+Seb (Rebellion) -------> WEC Formula E Day+Seb
NASCAR Cup
(JTG Daugherty) -------> NASCAR Cup
In the attached file, the values are written in column A starting at A2
Very grateful for your help
klin89
Bookmarks