Loop(?) giving divisor and the rest from the result

Hello,
Here's the thing, I want to make a formula which will divide my number by another fixed one, and as a result give me result of division and the rest (in another cell). I tried to make it using IF loop but its dead end, especially because big numbers are out of reach of formula. So, here's the example:

The number is 234, the fixed divider is 10, so the result is 23 and the rest placed in another cell is 4.
The number is 456, the result is 45 and the rest is 6.

Any ideas?

Thanks a lot in advance to anyone replying sharing thoughts!

With the number in A1, put this formula in B1:

=INT(A1/10)

to get the integer part, and this formula in C1:

=MOD(A1,10)

to get the remainder.

Hope this helps.

Pete

People are learning whole life. I should spend more time with Excel to know this basic functions. Cheers Pete_UK!

You're welcome - glad to be of help.

Pete