I wouldn't make the changes as part of the data entry. I would add the
extra spaces when the file is saved as a text file. I can esily write a
macro which would save the file and make the corrections when the file
gets saved.

Notepad is just a tool used to read text data. It doesn't have to get
copied and pasted into excel. You just need to save the file as text
with an TXT extension.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160414

Microsoft Office Help