Hi,
I imported some text files that have two columns of numeric values.
Those seem to have a fixed width, but after the import, there appears to
be a special character in the second column that is sometimes indicated
by an open/white square i.e., it cannot be displayed.
Surprisingly, this square is only displayed in my older XP 2002 (for
students and teachers) at home, but not in the newer Office 2003 version
on my work laptop. There, I was puzzling why Excel didn't want to plot a
graph from my table. At home, I realized that the special character not
shown at work was the reason.
First of all: can I make it happen that this special character (or its
replacement, the square) is also shown in newer Excel versions? How?
Also, is there any trick at the stage of the text file import that
allows me to see whether or not there is such a character, so that I can
exclude it?
Thanks,
Martin
Bookmarks