Parse string

[jasonhuibers]

In excel I have a list such as the following below.

Name=Joey, MANDATORY_BOOL
Name=Mike, MANDATORY_BOOL
Name=Jane, MANDATORY_BOOL

How can I parse each string and take only EVERYTHING BEFORE THE (, MANDATORY_BOOL) so the end result is:

Name=Joey
Name=Mike
Name=Jane

 

[SkipVought]

Hi

Why not use Data > Text to columns[\b] DELIMITED?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}