Converting rows of data in notepad to columns [Solved/Closed]

Report
-
 Philgood_FR -
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?

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3377 users have said thank you to us this month

limited to 256 cells as a row, how should I do for more than 800 words to split in one single column of 800 rows ?

Thanks :)