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/comm...et.f unctions

Carolyn E wrote:
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

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

Etc.

"Franz Verga" wrote:

Carolyn E wrote:
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