Solved Update:Text to Excel How-To's

Dell / DIMENSION 2400
March 8, 2012 at 13:55:58
Specs: MS-DOS 7.10, Pentium 4 / 1GB
I would like to suggest the following updates to two How-To's I wrote to condense superfluous whitespace, if it exists:

In "DOS Batch to Convert Text File with Rows & Columns to Excel Worksheet" please make the following changes:

FROM:

Delineate your column information with tabs in your text file (eg. "MyDoc.txt").
.
.
.
Step 3. Type a space in the "Find what:" field and a tab in the "Replace with:" field.

Step 4. Click on the "Find Next" button.
.
.
.

TO:

Delineate your column information with tabs in your text file (eg. "MyDoc.txt").
.
.
.
Step 3. Type two spaces in the "Find what:" field and one space in the "Replace with:" field.

Step 4. Then click on "Replace All" repeatedly until no more replacements are made.

Step 5. Now type only one space in the "Find what:" field and only a tab in the "Replace with:" field.

Step 6. Click on the "Find Next" button.
.
.
.


In "Convert Text File with Rows & Columns to Excel Worksheet" please make the following changes:

FROM:

Delineate your column information with tabs in your text file
.
.
.
Step 3. Type a space in the "Find what:" field and a tab in the "Replace with:" field.

Step 4. Click on the "Find Next" button.
.
.
.

TO:

Delineate your column information with tabs in your text file
.
.
.
Step 3. Type two spaces in the "Find what:" field and one space in the "Replace with:" field.

Step 4. Then click on "Replace All" repeatedly until no more replacements are made.

Step 5. Now type only one space in the "Find what:" field and only a tab in the "Replace with:" field.

Step 6. Click on the "Find Next" button.
.
.
.

Not shown steps should be renumbered as approprioate.


See More: Update:Text to Excel How-Tos

Report •

#1
March 8, 2012 at 14:35:58
✔ Best Answer
Hey,

I have made this change.

Thanks again for the update!
Justin


Report •
Related Solutions


Ask Question