Converting rows of data in notepad to columns

Need help - Aug 23, 2009 at 12:22 PM
 Philgood_FR - Feb 5, 2015 at 12:11 PM

Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains first name, last name, postal address and a whole host of other non related data. The challenge is that the data exists in "rows", and I need to import into excel in column format-that way I can clean up the unecessary data and continue with my mail merge. Sample of data in present format:


App. Name One: Anonymous Mr Dec 15, 1963
App. Name Two:
Corp. Name:
Address: PLOT 99 Witels Street

DELFT 7100
Business Entity: 570 South Africa Language:
E-mail Address:
Home Phone: Work Phone: 0799172800
Mobile Phone:

Can anybody help?

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Updated on Nov 26, 2019 at 05:33 PM
Highlight data in the notepad and hit: edit copy
Go to an excel sheet cell A1 hit: edit paste
Highlight the whole date in excel
Click data(menu)-text to columns
Choose "delimited" click next
Choose "others" and type in the small window a colon(:)
Click finish
Again highlight data
Edit copy
Go to another sheet A1
Now highlight data in second sheet click format(menu)-columns-autofit
Now you have to tweak the data because you have line like
Home Phone: Work Phone: 0799172800
It should be:

home phone

See help text to columns