Special Characters in Excel Importation

[chouna]

How do I turn off the feature of including special characters in Excel when I import? My colleagues can import properly without those characters (tab, carriage returns, line feed etc.) but I can't. What settings do I have to change? (My settings to Show Control Characters in the Option's International tab is unselected.)

 

[SkipVought]

Hi,

Save As .prn

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[chouna]

Skip,

I may have used the wrong term "import" but I was actually opening a text file with csv extension. My colleagues can open the file without those characters but in my system, I can't. Must have something to do with my settings.

By the way, how do you save a file as PRN?

Thanks

 

[chouna]

Sorry Skip but how do you save to PRN? I may have used the wrong term "import" but I was actually opening a text file with csv extension. My colleagues can open the file without those characters but in my system, I can't.

 

[SkipVought]

Sorry, I misread your request. IMPORT.

Change the extension from .csv to .txt.

The Text Import Wizard will appear and you can select how to parse.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[chouna]

Skip,

I am able to get the text import wizard but the problem is when the text file is opened, the control characters are visible in my machine. Having those control characters makes it hard for me to align the columns properly bec. the tabs (the file is delimited with semi-colon) move the columns to different headers. If I don't choose tabs, the columns will align properly but the tab control character (square box) appears along with the data.

If I open the file from another machine, I don't encounter that problem. I have checked their Options and I don't see anything different from mine but maybe I missed out something.

Chouna

 

[SkipVought]

Then you have OTHER control character in your source data.

Please copy 'n' paste a sample row UNCHANGED.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[chouna]

Skip,

Here is the sample data. Yes you're right, I have both the TAB and Semicolon characters. I just don't know how the tab got in there but it does not appear in other machines.

Date Device No. Warehouse No. ItemCode Type Refer Qty
02-Nov-04 " 0001" h1 " 0100031" IN 11 25
02-Nov-04 " 0001" h1 " 0100071" OUT 22 20

Please tell me if these would appear with TAB in your system.

Thanks.

 

[SkipVought]

No [TAB] characters.

No [SEMICOLON] characters.

Did you copy from the SOURCE DATA FILE???

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}