Separate two hours from one cell to two
 

I HAVE ANOTHER DOOZY!

In Column A, row 8 I show: A, S
In Column A, row 9 I show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (just the €œA€� amount)
I would like Column O, row 9 to show: 7 (just the €œS€� amount)

Separate two hours from one cell to two
 

use formula

in Column M9
=LEFT(A9,FIND(",",A9,1)-1)
if you want to error handle then use
=IF(ISERROR(LEFT(A9,FIND(",",A9,1)-1)),"",LEFT(A9,FIND(",",A9,1)-1))

in Column O9
=RIGHT(A9,FIND(",",A9,1)-1)
if you want to error handle then use
=IF(ISERROR(RIGHT(A9,FIND(",",A9,1)-1)),"",RIGHT(A9,FIND(",",A9,1)-1))

-kc
*Click YES if this helps

"something68" wrote:

I HAVE ANOTHER DOOZY!

In Column A, row 8 I show: A, S
In Column A, row 9 I show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (just the €œA€� amount)
I would like Column O, row 9 to show: 7 (just the €œS€� amount)

Separate two hours from one cell to two
 

Hi,

Try these

The "A" amount
=LEFT(A9,FIND(",",A9)-1)

The "S" amount and I have assumed the space after the comma is always there.
=MID(A9,FIND(" ",A9)+1,LEN(A9))

Mike



"something68" wrote:

I HAVE ANOTHER DOOZY!

In Column A, row 8 I show: A, S
In Column A, row 9 I show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (just the €œA€� amount)
I would like Column O, row 9 to show: 7 (just the €œS€� amount)