I need to split 1200130000001 into 3 columns of 5 characters but the final column only leaves 1 when I use "Text to Columns". I need it to be 00001. I have formatted as text but still doesn't help. How can I do this? Thanks.