Hi,
I need to separate a lot of data into two columns while preserving the leading zeros. I know how to separate them using "text to columns", but I'm losing the leading zeros. Here's what I'm trying to do:
002420 to 002 420
001650 t0 001 650
Presently it's doing this:
002420 to 2 420
001650 to 1 650
Any suggestions?
VG
I need to separate a lot of data into two columns while preserving the leading zeros. I know how to separate them using "text to columns", but I'm losing the leading zeros. Here's what I'm trying to do:
002420 to 002 420
001650 t0 001 650
Presently it's doing this:
002420 to 2 420
001650 to 1 650
Any suggestions?
VG