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

Compatible graphics card

Unable to make copies with epson wf-2630?

End of the pink paper driving license: here’s the date when you’ll really have to replace it

How to fix this type of issue?

Parking against the flow is still prohibited, even in a space.

Internet connection

How to disable avast alerts

Bizarre lenovo tablet keyboard

I shut down my macbook pro and it starts up by itself

The national assembly votes for a tax of 5.5 cents per gigabyte downloaded: a measure that ruffles feathers