Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I globally change all caps to lower case w/lst letter cap?
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. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I globally change all caps to lower case w/lst letter cap?
Open the file in Word and use FormatCase and select Title Case. May even
be able to do that in Excel. -- 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 "Mamalu" wrote in message ... 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. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How do I globally change all caps to lower case w/lst letter cap?
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 -- macropod [MVP - Microsoft Word] "Mamalu" wrote in message ... I have an Excel file with data in all caps. Would like to use it fora 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I automatically set Word to change case? | Microsoft Word Help | |||
Convert numeric value into english word | Microsoft Word Help | |||
Convert to Symbols | Microsoft Word Help | |||
changing all upper case document to all lower case document | Microsoft Word Help | |||
How do I turn dollar amounts into words? | New Users |