Converting rows of data in notepad to columns

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

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:

943850========================================

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?
Related:

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
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
Edit-pastepeical-transpose
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
workphone:0799172800

See help text to columns
8