Format text not all caps

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Justin (jdignam_at_sbcglobal.net)
Date: 02/02/04 

Date: Mon, 2 Feb 2004 10:04:32 -0800

I am doing a mail merge from an xls file into word. The excel file that I
purchased is in all caps, ie JOHN SMITH. I would like to change the xls
file to be John Smith. I see from excel Help something called Proper, but
it doesn't tell me how to apply it to columns or cells. How do I do this???
I have no problme actually performing the mail merge. The text needs to be
changed within excel so as not to change what I have in the word source doc
.

Thanks from Southern California.

Relevant Pages

  • Re: Format text not all caps
    ... > I am doing a mail merge from an xls file into word. ... > that I purchased is in all caps, ie JOHN SMITH. ... I see from excel Help ... > so as not to change what I have in the word source doc. ...
    (microsoft.public.excel)
  • Excel Mobile forces duplicate file creation in another location.
    ... If you port an XLS file from your desktop to a WM5 folder that is NOT ... After loading a newly-ported XLS file into Excel for the first time, ... HAS saved your edited file back to its CORRECT location. ...
    (microsoft.public.pocketpc)
  • Pivot table in HTTP-served Excel worksheet
    ... But once the file is loaded in Excel on my workstation, ... successfully create pivot tables (nor can I refresh pivot tables that are ... Cannot open PivotTable source file '[download.do? ... URL that is used to download the XLS file. ...
    (microsoft.public.excel.programming)
  • execute macro upon opening workbook
    ... But once the file is loaded in Excel on my workstation, ... successfully create pivot tables (nor can I refresh pivot tables that are ... Cannot open PivotTable source file '[download.do? ... URL that is used to download the XLS file. ...
    (microsoft.public.excel.crashesgpfs)
  • Refreshing a pivot table in HTTP-served Excel file
    ... But once the file is loaded in Excel on my workstation, ... successfully create pivot tables (nor can I refresh pivot tables that are ... Cannot open PivotTable source file '[download.do? ... URL that is used to download the XLS file. ...
    (microsoft.public.excel.crashesgpfs)