Truncate all text after (

fgd

New Member
Joined
Mar 3, 2004
Messages
49
I have a list of job titles and SOME of them have notes in parentheses, like this: Director (Part Time).

I want to write a query that produces the titles without the notes. In other words, all text after the ( would NOT appear. Titles without the ( would display the entire title.

I tried but to no avail.

Help?

Thanks
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,918
Office Version
  1. 365
Platform
  1. Windows
Try this.

OnlyTitle: Trim(Left([Title],InStr([Title],"(")-1))
 

giacomo

Well-known Member
Joined
Feb 20, 2002
Messages
1,796
IIf(InStr([job_title],"(")=0,[job_title],Left([job_title],InStr([job_title],"(")-2))

hth,
Giacomo
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,918
Office Version
  1. 365
Platform
  1. Windows
fgd

Stick with Giacomo's expression, mine doesn't check for the non-existence of the (, so will probably cause errors.:eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,679
Members
410,697
Latest member
srishtijain0708
Top