Inconsistant character spaces extraction formula
 

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.

Inconsistant character spaces extraction formula
 

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)

In article ,
Sneilan wrote:

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.

Inconsistant character spaces extraction formula
 

"Sneilan" wrote in message
...
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.

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

Inconsistant character spaces extraction formula
 

This is AWESOME. Thank you!

"Stephen" wrote:

"Sneilan" wrote in message
...
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.

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