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)
 
Back
Top