# One-digit and two-digit separation

You can use this formula: `=INT(A2/10)`

Máté Juhász's answer using `INT`

is probably the best solution. However, for the sake of curious future readers, there is another, clunkier way:

```
=VALUE(RIGHT(LEFT("0"&A2,LEN(A2))))
```

If your data ever goes up to more than two digits and you really want the tens place, not just the first digit, then `INT`

will fail. In that case, you can use this clunky version. If you want to pull the tens place for any number, it gets messier.

```
=VALUE(RIGHT(LEFT(TEXT(A2,"00"),LEN(TEXT(A2,"00"))-1)))
```

Use an IF statement since you're only concerned about a different rule if 1 digit (therefore, less than 10).

This is the cell value in C1

```
=IF(A1<10, 0 + F1, LEFT(A1,1) +F1)
```

It may seem odd to write `0 + F1`

but I'm not aware of what logic you're using so
I left it in to demonstrate the formula.