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