Reply
 
Thread Tools Display Modes
  #1   Report Post  
Island Girl
 
Posts: n/a
Default 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   Report Post  
Treesy
 
Posts: n/a
Default

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   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

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   Report Post  
Island Girl
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Locks Up Word Karine Rivet Formatting Long Documents 1 January 22nd 05 06:21 AM
Find and Replace Locks Up Word Karine Rivet Microsoft Word Help 0 January 21st 05 10:01 PM
Find and Replace anomaly BruceM Microsoft Word Help 7 January 18th 05 05:47 PM
--A Find & Replace Question-- KlikThis Microsoft Word Help 3 January 1st 05 05:58 PM
Find Replace bold formatting with delimiter Steve New Users 7 December 7th 04 03:41 PM


All times are GMT +1. The time now is 11:59 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"