Separate two hours from one cell to two

[something68]

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)

 

[KC]

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

 

[Mike H]

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