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

[Mamalu]

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.

 

[Doug Robbins - Word MVP]

Open the file in Word and use Format>Case 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

 

[macropod]

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