[EXCEL] convert from .xls to .txt Solved

Question

Hello,

in order to upload a database, I need to have a .txt file with ";" as the separator

My source file is a classic Excel file.

With the "save as" function in Excel I don't have the option to create a .txt file with ";" as the separator

Do you have any idea to help me???

Thank you in advance for your responses

Configuration: Windows XP Firefox 2.0.0.3

charlot · Accepted Answer

To have a separator of "";"", save as .csv Then, if you need a .txt file, you just have to copy the content of the file into Notepad.

jljljl · Answer

Under Excel: Save as... File name: xxxx File type: CSV (semicolon-separated).  If the txt suffix is required, rename the file xxxx.csv to xxxx.txt.

Skoot · Answer

Bonjour,

I also have a problem when I switch from an Excel file to a text file.

After a whole series of operations performed with a macro, I end up with an Excel file with a single column of the type:

550WA;Actual;FY06;Apr;BE;0;550WA_ANTWERPSEW;ANTWERPSE WATERWERKEN 550WA_ANTWERPSEW;550WA_WATX0071/0/DUAL;Magmaster main card AC 550WA_WATX0071/0/DUAL;M001;1130;EUR;EUR
550WA;Actual;FY06;Apr;BE;0;550WA_ANTWERPSEW;ANTWERPSE WATERWERKEN 550WA_ANTWERPSEW;550WA_Z-M;Manual Article 550WA_Z-M;M001;303;EUR;EUR
550WA;Actual;FY06;Apr;BE;0;550WA_APC;APC 550WA_APC;550WA_KMM30/260;WATER METER KMM 30 X 260MM 550WA_KMM30/260;M001;64;EUR;EUR

So far, no problem.

However, when I save this file in text format, a series of " are added before and after each line...
Hence, my text file contains:

"550WA;Actual;FY06;Apr;BE;0;550WA_ANTWERPSEW;ANTWERPSE WATERWERKEN 550WA_ANTWERPSEW;550WA_WATX0071/0/DUAL;Magmaster main card AC 550WA_WATX0071/0/DUAL;M001;1130;EUR;EUR"
"550WA;Actual;FY06;Apr;BE;0;550WA_ANTWERPSEW;ANTWERPSE WATERWERKEN 550WA_ANTWERPSEW;550WA_Z-M;Manual Article 550WA_Z-M;M001;303;EUR;EUR"
"550WA;Actual;FY06;Apr;BE;0;550WA_APC;APC 550WA_APC;550WA_KMM30/260;WATER METER KMM 30 X 260MM 550WA_KMM30/260;M001;64;EUR;EUR"

So, how do I remove these quotes

Best regards

Vincent

[EXCEL] convert from .xls to .txt

3 réponses

Windows spotlight is not working.

Samsung j5 unable to answer

Scam of the suvedene highway

Remove 360 antivirus

My pc's screen is flickering.

Fujitsu siemens laptop won't start anymore

Wearline: what do you think?

Eko tank smartwatch

Ibiza sound reviews

Only one of my iphone headphones works. what to do?