'Text to Excel Wizard' FAQ

Text to Excel Conversion Software

Questions and Answers

Any other known bugs or Issues?

See Change History for version to version details.  Also, Please submit a bug if you find one.

Back to Top


Is there any way of picking up just a single character and creating a column of one character?

Single character width columns are possible. For example try the text below:

>>1
- - - - ----------------------
1 2 3 4 Table 1 Example Row 1
1 2 3 4 Table 1 Example Row 2
1 2 3 4 Table 1 Example Row 3
1 2 3 4 Table 1 Example Row 4
1 2 3 4 Table 1 Example Row 5
<<1

>>2
=
1 2 3 4 5 Table 2 Example Row 1
1 2 3 4 5 Table 2 Example Row 2
1 2 3 4 5 Table 2 Example Row 3
1 2 3 4 5 Table 2 Example Row 4
1 2 3 4 5 Table 2 Example Row 5
<<2

Also, try this for single character lines:

>>1
--
A
B
C
<<1

>>2
- - --
a b c
a b c
a b c
<<2

Back to Top


I'm losing the first few "0"s in my strings, "0000231" becomes "231". How an I retain all the "0"s?

If you are using the Profile method, go to the options and enable the "Treat values as text" option.

For Recipe and Mark up methods, pre-format an Excel file with the FORMAT of the CELLS set to TEXT.  This is the text file you will be copying the text into.  Next, the input text file will have to be modified, you'll have to prepend an apostrophe before all instances of strings that may have an issue with leading zeros.

>>1
--------  -------
'0001234 '004321
<<1

Back to Top


A blank message box pops up

You might be able to get around this issue by looking within the INI file (config.ini) and look for this item:

    bWarnedAboutProductLimitations=FALSE

and change it to:

    bWarnedAboutProductLimitations=TRUE

Back to Top