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
 

Forum statistics

Threads
1,077,827
Messages
5,336,614
Members
399,093
Latest member
chado4250

Some videos you may like

This Week's Hot Topics

Top