Home » Questions » Computers [ Ask a new question ]

data from word to excel

data from word to excel

"Hai ,
I have a word file with n number of employee address in it... Now i want to convert it to an excel file... I am using windows xp.. Is there a way to do so?"

Asked by: Guest | Views: 320
Total answers/comments: 1
Guest [Entry]

"In Word, reformat the data to be tabular - each field separated by tabs, each record on a separate line:

Press Ctrl+H to bring up the Find & Replace window.
In the ""Find what"" box, type ^p^p, and in the ""Replace with"" box, type ^l. Press the Replace All button. [This replaces any two consecutive paragraph marks with a line break. It assumes that your records are separated by a blank row, which is what it looks like in your example.]
Now type ^p in the Find what box, and ^t in the Replace with box, then Replace All. [This replaces any remaining (single) paragraph marks with tab characters.]
Probably optional, but just for completeness, type ^l in Find what, and ^p in Replace with, then Replace All. [This replaces the line breaks from step 2 with paragraph marks.]

Now you can simply copy & paste the data into Excel."