File Transfer Notepad --- Excel

Question

Hello everyone,
I'm new and I need some advice. I have a contact file (Last name, First name, Address...) that opens with Notepad. I want to transfer it to Excel to create a mailing. Is it possible, and if so, how do we do it...? Thank you in advance.

Configuration: Windows XP Internet Explorer 7.0

Tippy · Accepted Answer

Hello,
If the information in your text file is formatted like
LASTNAME1 FIRSTNAME1 Address1
LASTNAME2 FIRSTNAME2....

You can open them in Excel by selecting your file in "Open" > file type "Text File (*.prn, *.txt, *csv)
From there, the wizard will ask you the type of delimiter (comma or other) that separates your items.

rasta67 · Answer

Hello,
yes, it's possible,
it's to insert a VBA macro into the Excel file that will fetch the information from the Notepad file.
However, you need to know the VBA language. (maybe you can find some examples on the internet)

ali · Answer

Open a blank file in Excel
- Click on Open and choose your file (.txt)
- Follow the wizard; it will give you the option to size the columns according to your preferences.
- After opening the file, save it as an Excel file.

voixetre · Answer

Yes for converting from Notepad to Excel, you need to open it with Excel and go to the convert option, then set the line separators for the columns.

File Transfer Notepad ---> Excel

4 answers

Doctolib document

Capistars.fr

This solar-powered, gps-enabled agricultural robot sows and weaves weeds by itself (and without pesticides)

Missing lock icon

Anomalies in my laptop usage: virus?

Meetic change main photo

Avoid driving on august 1st, the worst day for summer traffic.

Self-invoking js function

Suspicion of network compromise / public ip

Full screen mode