Determining variable length (number of digits) possible?

[CuriousOne]

So back to shift.
How to trim one variable from left to right, to value of another variable?

say trim 12345 by 3 - mean, make 123 digits from it.

[HenrikOlsson]

12345 / 10 = 1234
12345 / 100 = 123
12345 / 1000 = 12
12345 / 10000 = 1

/Henrik.

[CuriousOne]

This requires too many IFs....
On spectrum we had X=LEFT(Y,Z)....

[Ioannis]

You are mixing string with numeric values...

12345 is a decimal number.

LEN or any other similar command (LEFT, RIGHT, MID) will take as an input just string characters, not numeric values.

Ioannis

[pedja089]

Look up DIG. It isolates single digit, as you need it, without IF...