Hello All,

I have searched the previous posts but have not been able to find an answer.

I need to be able to read an Excel string to work out what is on each side of the decimal point.

For example in my Excel sheet C36 may contain 16.11

I wanna be able to split the string so I have 16 in one box and 11 in the other.

The number next time may be 6.1 so I need to end up with 6 in one box and 1 in the other.

Thats where I have had no success with the Right(C36,2) function as in some cases I may need to use Right(C36,1) as it always varies.

Any help would be appreciated.

Thanks.