2
Have a number of text files which have numbers next to names, tab delimited:
000454 Name1
005005 Name2
000643 Name3
4043 Name4
33643 Name5
I frequently need to import it into excel to do things. But when I import it in excel it removes all those leading zeroes. I can't do a concatenate to add two zeroes to the beginning because some never have zeroes infront to begin with, and then becomes a painful manual process of rechecking and adding.
So my question is how can I import it into excel without this happening ?
Cheers