Hi there,

Let's say in cell A1 I have the number 1234.56
Does anyone know a relatively easy way to separate the digits in the hundreds place and higher in one cell and the digits in the tens place and lower in another?

For example, I want to take A1 and in one cell display "12" and in another cell display "34.56"

Using the functions LEFT or RIGHT does not work for me because I need this to work no matter how many digits are in a cell. So the number 123.45 will be 1 and 23.45, the number 12.34 will be 0 and 12.34, the number 12345.67 will be 123 and 45.67 etc....

I hope my question makes sense and thanks for any help you can give me!