regexp character exclude \r and \n

[klin89]

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

Please Login or Register  to view this content.

klin89

[MarvinP]

Hi Klin89 and welcome to the forum.

I expected to see some blanks in your cells but didn't. See if this simple formula works instead of any VBA.

=TRIM(LEFT(A2,FIND("(",A2)-1))

klin89 answer1.xls

[jindon]

Is this how you wanted?

Please Login or Register  to view this content.

[klin89]

Hello everyone,

Thanks for your reply, however, I had to express myself very badly
The lines are separated by a carriage return in the cell.
I need a macro to keep only the discipline that precedes the parentheses, without leaving space at the end of the string

The picture below shows the desired result

photo1.JPG

klin89

[jindon]

Then change the pattern in your code to

Please Login or Register  to view this content.

[MarvinP]

OK - try this code to do what you want. Run it in the attached...

Please Login or Register  to view this content.

VBA Split vbNewLine to Rows.xls