Pulling specific text from between Parentheses ()

iwilli

New Member
Joined
Jan 31, 2012
Messages
43
So here is my dilemma. I have a worksheet I export daily and it contains the name of the individual who opened the account but is have the name inside parentheses. I have another worksheet that has just the account number and I need just the individual name from the other worksheet. I have been using =IFERROR(INDEX('Dashboard Export'!K:K,MATCH(Tracker!H:H,'Dashboard Export'!L:L,0)),"") to grab the info but it grabs everything in that cell and I just want the name between the parentheses. I found this formula =MID(K22,SEARCH("(",K22)+1, SEARCH(")",K22)-SEARCH("(",K22)-1). But I can't for the life of me figure out how I would use both formulas to get what I want. Anyone have any suggestions for me?

Thanks a buch
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Watch MrExcel Video

Forum statistics

Threads
1,089,877
Messages
5,410,923
Members
403,334
Latest member
SH2020

This Week's Hot Topics

Top