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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks