ADD Change Case function from Word to Excel

[Guest]

I am invariably typing text into Excel for Mail Merge Lists and would love to
just type straight and convert the text using a Change Case Funtion such as
you find in Word (Format Change Case) in order to have the proper Caps so the
finish document comes out clean.

I think that the flow of data for long mail merge spreadsheets would be
significantly easier for the Data Input Person if MS would just "cut and
paste" this function into Excel from Word.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[Franz Verga]

I am invariably typing text into Excel for Mail Merge Lists and would
love to just type straight and convert the text using a Change Case
Funtion such as you find in Word (Format Change Case) in order to
have the proper Caps so the finish document comes out clean.

I think that the flow of data for long mail merge spreadsheets would
be significantly easier for the Data Input Person if MS would just
"cut and paste" this function into Excel from Word.

Hi Carolyn,

In Excel you have Upper, Lower and Proper functions to manipulate text.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Guest]

If you have "dave friedman" in A1, use: =PROPER(A1), the result being "David
Friedman"

Etc.

 

[amays]

The best Excel Change Case Add-In can be found at the following link

http://www.nucleation.in/2012/07/change-case-excel-add-in.html

In this add in, change case functionality is incorporated to the context menu, which makes it very easy to use.

This Add-In has the following features
a. Change case of selected cells to ‘UPPER CASE’
b. Change case of selected cells to ‘lower case’
c. Change case of selected cells to ‘Proper Case’
d. Change case of selected cells to ‘Sentence case’
e. Change case of selected cells to ‘tOgGlE cAsE’
f. Customizable shortcut keys to perform change case actions