- I have 2 columns A and B.
- Column A is the list of numbers of 8 numbers, column B is the list of numbers that just have 1 number
A1= 12345678 B1= 9
A2= 123456789 B2= (EXTRACT(A2;9;1))
But there are some cells from column A that have 9 numbers, so the last number has to go in column B.
I know how to use extract but if I run the function I have cells that are already fixed so it doesn't work. So I just need a function that doesn't erase the number of certain cells in column B.