Forum Discussion
data in 1 cell . Split into 4 cells
I need to split a 14 digit number (saved as text) into 4 different columns Ex. Split 24001001000100 into this: 24 001 0010 00100
I can do this using the text to columns function however, it removes the 0's and I need those
Hello
You did not set the data format "Text" for the four columns in step 3.