Microsoft KB Archive/61448

Word: Change Uppercase Text to Lowercase Text Using Excel PSS ID Number: Q61448 Article last modified on 08-08-1993 PSS database name: M_WorD

3.00 3.01 3.02 4.00

MACINTOSH

Summary:

Microsoft Word for the Macintosh does not have an option to change uppercase text to lowercase text. However, you can do this by using the LOWER function in Microsoft Excel.

To convert uppercase text to lowercase text in Excel:

  In Word, save the document as text with line breaks. (Saving as text only will drop any characters in a paragraph over 256 in Excel.)   Open a new Excel worksheet, choose Open from the File menu and open the Word text file.   Select column A and choose Insert from the Edit menu (this will move the text to column B leaving column A blank).   Place your cursor in cell A1 and type the following: =LOWER(B1) Press RETURN to enter the formula. The contents of B1 will be entered into A1 with lowercase formatting.   With A1 highlighted, extend the selection down to match the length of text in column B. Choose Fill Down from the Edit menu.   With the cells in column A still selected, choose Copy from the Edit menu, then choose Paste Special from the Edit menu and select Values.   Delete column B, save the worksheet as text and launch Microsoft Word and open the file.   Choose Change from the Utilities menu, to find and replace any unwanted paragraph marks (^p will locate paragraph marks). </li></ol>

Other related Excel functions are PROPER and LOWER.

Note: If the selection in Excel is copied and pasted into Word, it will be pasted as a table. Use the Table To Text feature (from the Document menu) in Microsoft Word to convert the table into paragraph format. (The text will also need to be reformatted.)

Additional reference words: mswdformula upper lower case

Copyright Microsoft Corporation 1993.