Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
I thought I had the job done and then --
I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
To keep each address in a block, replace ^p (paragraph break) with ^l (line
break), then replace ^l^l with ^p. -- 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 thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels...mail_merge.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 14 May 2007 16:10:15 -0700, Island Girl wrote: I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
Thanks, as always, Suzanne for your reply.
One more thing. Is it possible, after replacing the paragraph breaks and line breaks as you suggested, to keep the address block together with the name while at the same time rearranging the name in the first line of each block to last name first? What I'm trying to avoid in my now hazed mind is separating all the names from the address block, rearranging them, and then putting them back in their proper place. I've been thinking so hard that I'm probably not making sense. Thanks for all you do and have done, Suzanne! "Suzanne S. Barnhill" wrote: To keep each address in a block, replace ^p (paragraph break) with ^l (line break), then replace ^l^l with ^p. -- 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 thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
Since I don't know how you're rearranging the name, I can't offer any
further help, but each address block is now a single paragraph and can be handled as such. As Jay suggests, however, converting the text to a table and using it as a mail merge data source is a more satisfactory approach. -- 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 ... Thanks, as always, Suzanne for your reply. One more thing. Is it possible, after replacing the paragraph breaks and line breaks as you suggested, to keep the address block together with the name while at the same time rearranging the name in the first line of each block to last name first? What I'm trying to avoid in my now hazed mind is separating all the names from the address block, rearranging them, and then putting them back in their proper place. I've been thinking so hard that I'm probably not making sense. Thanks for all you do and have done, Suzanne! "Suzanne S. Barnhill" wrote: To keep each address in a block, replace ^p (paragraph break) with ^l (line break), then replace ^l^l with ^p. -- 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 thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
This is not the first time that Suzanne, you and Graham have made me happy!!
"Jay Freedman" wrote: Graham Mayor covers exactly that situation in http://www.gmayor.com/convert_labels...mail_merge.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Mon, 14 May 2007 16:10:15 -0700, Island Girl wrote: I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
As an alternative to Suzanne's suggestion - this is a standard data format.
You can create any finished layout you want from that data by running a mailmerge to Directory format. If you just want the address list sorted see http://www.gmayor.com/convert_labels...mail_merge.htm covert it to a table, sort on whichever column you want then convert back to text (or if you want it for mail merge etc, leave it as a table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org . Island Girl wrote: I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
Ooops - I should have read all branches of the thread before replying
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jay Freedman wrote: Graham Mayor covers exactly that situation in http://www.gmayor.com/convert_labels...mail_merge.htm. I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#9
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
It's always comforting to see your name, Graham. I used your website method
and everything worked out just fine. Thanks! "Graham Mayor" wrote: Ooops - I should have read all branches of the thread before replying -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jay Freedman wrote: Graham Mayor covers exactly that situation in http://www.gmayor.com/convert_labels...mail_merge.htm. I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
#10
Posted to microsoft.public.word.newusers
|
|||
|
|||
An even bigger Find and Replace
Glad someone appreciates what I do
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Island Girl wrote: It's always comforting to see your name, Graham. I used your website method and everything worked out just fine. Thanks! "Graham Mayor" wrote: Ooops - I should have read all branches of the thread before replying -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Jay Freedman wrote: Graham Mayor covers exactly that situation in http://www.gmayor.com/convert_labels...mail_merge.htm. I thought I had the job done and then -- I have now been sent an address list formatted as follows: John A. Jones [paragraph mark] 2111 Alabama Street [paragraph mark] Miami, FL 33131[paragraph mark] [paragraph mark] Mary Smith [paragraph mark] 50 Park Place [paragraph mark] Miami, FL 33131 [paragraph mark] [paragraph mark] In other words each last line of the address is followed by two paragraph marks. I know how to change last names first if the names are on a line by themselves, but I don't know if there's a way keep the address with the name at the same time. There are over 200 and, as usual, they say, "It's a rush!" What now, coaches? Thanks so very much for any advice on how to approach and also any find and replace or macro information. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find multiple characters in one find using MSword find/replace | Microsoft Word Help | |||
How to Find a 'Printing' Paragraph symbol using 'Find & Replace' | Microsoft Word Help | |||
Trying to replace words with fields using Find/Replace | Microsoft Word Help | |||
Using find and replace or macros to replace page ranges | Microsoft Word Help | |||
Find/ Replace is auto-capping the words I want to replace with | Microsoft Word Help |