Put this in M9:

=LEFT(A9,SEARCH(",",A9)-1)

and this in O9:

=RIGHT(A9,LEN(A9)-SEARCH(",",A9))

These will be text values, but if you want them to be numbers you can
do this:

=--LEFT(A9,SEARCH(",",A9)-1)

and:

=--RIGHT(A9,LEN(A9)-SEARCH(",",A9))

Hope this helps.

Pete


On Sep 14, 1:44*pm, something68
wrote:
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 extract “1” from column a, row 9
I would like Column O, row 9 to extract “7” from column a, row 9