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