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