Jan 11 2019 12:44 PM
I need to split a 14 digit number (saved as text) into 4 different columns
Ex. Split 24001001000100
into this: 24 001 0010 00100
Jan 11 2019 01:18 PM
I can do this using the text to columns function however, it removes the 0's and I need those
Jan 11 2019 01:45 PM
Hello
You did not set the data format "Text" for the four columns in step 3.
Jan 11 2019 01:51 PM
Hi,
Please try this formula:
=MID($A$1,CHOOSE(COLUMN(A1),1,3,6,10),COLUMN(A1)+1)
Let's say the number is in cell A1 as the screenshot above, then copy the formula in cell B1 and drag it to the right.
Hope that helps