Extract a specific portion of text as new cell value

  • Thread starter Thread starter Craig860
  • Start date Start date
C

Craig860

I have a question for the excel masters. (genuflect)

If I have a list of values in a list that contain some unwanted text. For
example:
(jblow)
(mjane)
(jqpublic)

Basically I want a new cell that has the mjane or the jblow without the
parenthesis.
I can't figure out a function that will search for the parenthesis.
 
Highlight the column, go to Edit, select Replace, First, put in ( in 'Find
what' and select Replace all. Do again for ).
 
This will be a lesson to me in being more specific.
Cell a1 = Jane, Mary (mjane)
i'd like b1 to = mjane
 
Column B - =FIND(")",A1,1)
Column C - =FIND("(",A1,1)
Column D - =MID(A1,D1+1,(C1-D1-1))
Highlight Column D and Copy and Past Special / Values. Then you can delete
Column B and C
 
I'm getting a circular reference error when I entered the column D formula
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for extracting text formated numbers within ( )'s as numbe 5
Extract portion of a cell 4
extract a phone number from formatting 3
Numbers change in cell even when formatted as text 4
Auto Insert Parenthesis 3
turn text into a formula 1
Formula to return a value for a portion of a text string in a cell 2
Extracting/deleting select data from range of cell 4

Back
Top