How do I globally change all caps to lower case w/lst letter cap?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mamalu - 20 Jun 2006 22:50 GMT

I have an Excel file with data in all caps. Would like to use it fora mail
merge, but don't want the text to come out in caps. Prefer lst letter
capitalized with the rest of each word in lower case. Tried opening the file
in Word and using Autocorrect, but no, doesn't work.

Reply to this Message

Doug Robbins - Word MVP - 21 Jun 2006 04:46 GMT

Open the file in Word and use Format>Case and select Title Case. May even
be able to do that in Excel.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have an Excel file with data in all caps. Would like to use it fora mail
> merge, but don't want the text to come out in caps. Prefer lst letter
> capitalized with the rest of each word in lower case. Tried opening the
> file
> in Word and using Autocorrect, but no, doesn't work.

Reply to this Message

macropod - 21 Jun 2006 11:09 GMT

Hi Mamalu,

With your mailmerge field, you could add either:
. a pair of '\* Lower' and '\* FirstCaps' switches to capitalise the first
letter of the first sentence - all other words will be lower case; or
. a single '\* Caps' switch to capitalise the first letter of each word.

To do either:
. select the mergefield (eg «ExcelData»)
. press Ctrl-F9 to expose the code (eg { MERGEFIELD ExcelData })
. add the required switch(es) to the end of the field (eg { MERGEFIELD
ExcelData \* Lower \* FirstCaps} or { MERGEFIELD ExcelData \* Caps})
. press F9 to update the field (this step is optional)
. run your mailmerge.

Either approach avoids the need to alter the formatting in Excel.

Cheers

Signature

macropod
[MVP - Microsoft Word]

> I have an Excel file with data in all caps. Would like to use it fora mail
> merge, but don't want the text to come out in caps. Prefer lst letter
> capitalized with the rest of each word in lower case. Tried opening the file
> in Word and using Autocorrect, but no, doesn't work.

Reply to this Message

Rate this thread: