Inconsistant character spaces extraction formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the information in parenthasies out, into another cell.

My simple extration formulas aren't working since the character spaces are
inconsistent.
 
One way:

=MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255)

where 255 is just a large number

If you need the value to be a number:

=--MID(LEFT(A1,FIND(")",A1)-1),FIND("(",A1)+1,255)
 
Sneilan said:
The following type of data are listed in a column of cells:
Mon 1:30 (4:30)
Mon 10 (1)
Thurs 2 (5)

I need to get the information in parenthasies out, into another cell.

My simple extration formulas aren't working since the character spaces are
inconsistent.
Click to expand...

Try this:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
 

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

Extracting abbreviated days, converting to full word 4
Need Formula to Calculate Time/Overtime 2
Multiple Variable Formula 1
combining functions 2
Formula for Average 3
Excel 2002: How to extract characters ? 5
formula or calculation for adding negative hour and positive hours 1
How do I add a list of numbers in a colum that = a repeating word. 2

Back
Top