Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Find and Replace
I was just sent a list of names and addresses. Each line after the name and
after the address is followed by a paragraph mark. Each entry (name and address) is separated by two paragraph marks. It needs to be alphabetized according to last name. I know how to alphabetize the names according to last name only in Find and Replace, but how can I get just the names in a single table or column? Any suggestions about how to do this more quickly than I am currently able to would be appreciated. Thanks for all you do. |
#2
|
|||
|
|||
Are you talking about converting text to table format? If so, select the
text and go to Table | Convert. There you can select "Text to Table"... it will bring up a box that will ask how many columns you want, etc. You can also convert a table to text so if you alphabetize it as a table, you can convert it back to text. Good luck! "Island Girl" wrote: I was just sent a list of names and addresses. Each line after the name and after the address is followed by a paragraph mark. Each entry (name and address) is separated by two paragraph marks. It needs to be alphabetized according to last name. I know how to alphabetize the names according to last name only in Find and Replace, but how can I get just the names in a single table or column? Any suggestions about how to do this more quickly than I am currently able to would be appreciated. Thanks for all you do. |
#3
|
|||
|
|||
Start by grouping each address block into a single paragraph. Do that by
replacing paragraph breaks (^p) with line breaks (^l). Then replace two line breaks (^l^l) with a paragraph break (^p). At this point, if each name consists of just a first name and a last name, you can sort the list by Word 2. If there are titles, middle names or initials, or other complications, some hand tweaking will be required. If you want to convert this information to a mail merge data source, then you can start by converting the text to a table. Replace each line break with a tab (^t), then Table | Convert | Text to Table separating at tabs. That will give you a row for each record and a column for each line of the address block. You'll probably want to break it down further, especially to be able to sort on last name. See http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Island Girl" wrote in message ... I was just sent a list of names and addresses. Each line after the name and after the address is followed by a paragraph mark. Each entry (name and address) is separated by two paragraph marks. It needs to be alphabetized according to last name. I know how to alphabetize the names according to last name only in Find and Replace, but how can I get just the names in a single table or column? Any suggestions about how to do this more quickly than I am currently able to would be appreciated. Thanks for all you do. |
#4
|
|||
|
|||
Thanks, Suzanne. This will get me through the season!
"Suzanne S. Barnhill" wrote: Start by grouping each address block into a single paragraph. Do that by replacing paragraph breaks (^p) with line breaks (^l). Then replace two line breaks (^l^l) with a paragraph break (^p). At this point, if each name consists of just a first name and a last name, you can sort the list by Word 2. If there are titles, middle names or initials, or other complications, some hand tweaking will be required. If you want to convert this information to a mail merge data source, then you can start by converting the text to a table. Replace each line break with a tab (^t), then Table | Convert | Text to Table separating at tabs. That will give you a row for each record and a column for each line of the address block. You'll probably want to break it down further, especially to be able to sort on last name. See http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Island Girl" wrote in message ... I was just sent a list of names and addresses. Each line after the name and after the address is followed by a paragraph mark. Each entry (name and address) is separated by two paragraph marks. It needs to be alphabetized according to last name. I know how to alphabetize the names according to last name only in Find and Replace, but how can I get just the names in a single table or column? Any suggestions about how to do this more quickly than I am currently able to would be appreciated. Thanks for all you do. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace Locks Up Word | Formatting Long Documents | |||
Find and Replace Locks Up Word | Microsoft Word Help | |||
Find and Replace anomaly | Microsoft Word Help | |||
--A Find & Replace Question-- | Microsoft Word Help | |||
Find Replace bold formatting with delimiter | New Users |