How to isolate for a portion of text

[clammy81]

Hello Fellow Excel Users,

I'm looking at creating a dynamic data-base and I have a ton of raw data.

I am having an little bit of an issue as I want to isolate for a portion of texts from A1:A436

For example:

Matt Smith (SR)
Derek Jost (SR/MR)

I'm familiar with the "RIGHT" function, however, I'm not too sure if there's a way to strictly isolate for texts within a bracket.

I would like "SR" to appear in a position column for Matt Smith
I would like "SR/MR" to appear in a position column for Derek Jost

I would appreciate any help as I would prefer not to do this process manually.

Thanks,

Clammy81

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[Tony Valko]

Here's another one...

Data Range

	A	B
1	Matt Smith (SR)	SR
2	Derek Jost (SR/MR)	SR/MR

This formula entered in B1 and copied down:

=SUBSTITUTE(MID(A1,FIND("(",A1)+1,20),")","")

[clammy81]

Thank you so much to both of you!

One more thing would it be possible to break first name and last name up into separate columns?

I can do the first name no problem.

The last time I'm having issue due to the bracket positions

Smith (SR) arghh I don't want the bracket in this instance just "Smith"

[Tony Valko]

Here's the whole thing...

Data Range

	A	B	C	D
1	Matt Smith (SR)	Matt	Smith	SR
2	Derek Jost (SR/MR)	Derek	Jost	SR/MR
3	Ed Van Halen (LG)	Ed	Van Halen	LG

First name:

=LEFT(A1,FIND(" ",A1)-1)

Last name:

=MID(A1,FIND(" ",A1)+1,FIND("(",A1)-3-FIND(" ",A1)+1)

Position:

=SUBSTITUTE(MID(A1,FIND("(",A1)+1,20),")","")

Assumes no 2 word first names!

[clammy81]

Solved! thanks

[Tony Valko]

You're welcome. Thanks for the feedback!