Need help converting notepad/txt file to Excel

Q

QuestionMan

Hi,

Have data in a notepad/txt file in the following format:
Joe Smith
123 Main St
Anytown, AA 07340

Want this in Excel in the following format (5 columns 1 line).

First Last Address City State Zip

I've done this before, but don't recall the specifics with deliminated file
and such and can't figure out so will let you pros guide me.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help converting .txt(notepad) file to Excel (2000) 1
Converting Numbers from Excel to TXT files 1
Export as XML for an Excel Order form document 1
Notepad or .txt file to excel 3
How to do batch job of converting TXT-files from ANSI to Unicode 1
Analyze & Filter data in a notepad file 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
HOW DO I CONVERT A .TXT FILE TO EXCEL 2

Top