Hi,
Good morning from S'pore. I am a novic excel user. Here is my question:
I have 10,000 sets of numbers, ranging from 0000 to 9999 keyed into 10,000 rows. Is there anyway to split these 10,000 sets of numbers into 4 columns?
For instance, column A containing 6789 (*note: no spacing) to be split into:
Column B: 6
Column C: 7
Column D: 8
Column E: 9
Thank you!
Bookmarks