Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mluera
 
Posts: n/a
Default Convert Word address list to Excel

I'm trying to convert an old address list written in word into an excel
spreadsheet.. The addresses are basic 3 lines (name, address, city, state,
zip). Other than copying each item into each cell individually, is there a
way to do this more efficiently?
  #2   Report Post  
Aysendak
 
Posts: n/a
Default

If each line of the list is ended with a hard return, then replace each hard
return with a tab. Use the Replace All function. Once the whole list is
tabbed, highlight the text, click on Table, then Convert text to table. Make
sure you pick "Separate text at Tabs". Then clean up your table. Once it is
in a good condition, select the whole table and paste it into an Excel
spreadsheet.

Make sure you copy the original list to a new document first before doing
the replace function. This way your list will still be intact. Hope this
helps.

"Mluera" wrote:

I'm trying to convert an old address list written in word into an excel
spreadsheet.. The addresses are basic 3 lines (name, address, city, state,
zip). Other than copying each item into each cell individually, is there a
way to do this more efficiently?

  #3   Report Post  
Junior Member
 
Posts: 6
Default

Quote:
Originally Posted by Mluera View Post
I'm trying to convert an old address list written in word into an excel
spreadsheet.. The addresses are basic 3 lines (name, address, city, state,
zip). Other than copying each item into each cell individually, is there a
way to do this more efficiently?
Meredith? Are you still around here?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create price list from excel sheet -keevill- Excel Discussion (Misc queries) 1 February 8th 05 01:02 AM
how do i convert MS Word mailing labels into an Excel mailing lis. unrhyll Excel Discussion (Misc queries) 1 February 4th 05 01:19 AM
Is there a way to create a drop-down list of links in Excel? t_boden Excel Worksheet Functions 1 February 3rd 05 07:14 PM
Getting specific data from a word document into an excel sheet smintey Excel Worksheet Functions 3 December 7th 04 06:17 PM
most effective way to link ms word tables to excel Mark S Lloyd Excel Discussion (Misc queries) 0 November 26th 04 09:11 PM


All times are GMT +1. The time now is 06:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"