thanks
-Original Message-
From: Tom Jeffries
Sent: Friday, April 03, 2009 10:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Convert excel file to .txt
Attached is an updated version that handles the alphanumeric data in column
2 correctly.
Tom
On Thu, Apr 2
Attached is an updated version that handles the alphanumeric data in column
2 correctly.
Tom
On Thu, Apr 2, 2009 at 7:56 PM, Cesar Delanoval wrote:
> Tom, the formula works great except for column 2. On this column I have
> data that is alpha numeric, The data could be from 1 digit up to 13 d
Tom, the formula works great except for column 2. On this column I have
data that is alpha numeric, The data could be from 1 digit up to 13 digits
( mostly it is an eight digit alpha field).
On this field I need to complete the field with zeros to the left, for
instance if the field is 123-W67
The attached workbook contains a macro (CvtToText) that does what you
describe. You may want to change variable FilePath to define the location
of the text file.
If you have any questions let me know.
Tom
On Wed, Apr 1, 2009 at 4:43 PM, Cesar Delanoval wrote:
>
> I need to know if anyone can he
