Software

Ask something
Discussion Locked

Double quote in Excel 2000

0 helpful
8 replies

by gmeloche

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I use Excel 2k for transfering files and has to be in tabulation(txt) or comma(csv) format. If the text contain for ex: [frame 3"x4"] then Excel will transfer the file in ["frame 3"""x4"""]. So is their a way to remove those extra " ???

8 replies

by dklippert

Here area few places to look:

http://www.cpearson.com/excel/imptext.htm

http://www.tushar-mehta.com/ (Text Write)

http://www.cpearson.com/excel/imptext.htm

But the major problem is the use of an apostrophe and double quote mark for feet and inches. This is left over from the type writer days.
The correct symbol for feet is a single prime mark; double prime for inches. If you use those symbols, you won?t have any problems. Because they are not Quote marks, Excel or any other program treats them as just another character.
In Word you can produce the prime symbol by typing 2032 and then Alt+x. (2033 is a double prime). I haven?t been able to make that work in Excel, but you can use insert Symbol in Excel 2002 (set for Unicode).
In Excel 2000 you can paste from Charmap. Go to Start>Run and enter Charmap. If it?s not installed you?ll need to go the Add/Remove programs Windows Accessories route. In Charmap use the Advanced option to look for the code.

Such a simple thing to cause such problems!

by dklippert

You can also save as a PRN file and then change the extention. There is also Unidode TXT format.

by vt100

Try running Edit;Replace;Find what: "";Replace with: ". You can create macro that would do that for you at the end of each export session.

This discussion is closed to new replies.