Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beagle Lover
 
Posts: n/a
Default How do I change a name to titlecase in Excel?

I need to change names that are in capital letters in an Excel Spreadsheet to
titlecase (eg: HARRY to Harry).
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default How do I change a name to titlecase in Excel?

=PROPER(A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Beagle Lover" <Beagle wrote in message
...
I need to change names that are in capital letters in an Excel Spreadsheet

to
titlecase (eg: HARRY to Harry).



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to change the color of all series in an excel chart in one go. Marielle Charts and Charting in Excel 2 May 3rd 23 07:45 PM
how to change range for dynamic chart in excel 2000 with button? ivan Charts and Charting in Excel 2 April 24th 05 04:10 AM
Excel renames sheet (repaired) when trying to change data from a . Debbie Excel Worksheet Functions 0 April 20th 05 08:15 PM
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
Excel should have a quick and simple "change case" function like . NinaSvendsen Excel Worksheet Functions 1 January 28th 05 03:15 PM


All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"