LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Robert Judge
 
Posts: n/a
Default How to change ALL CAPS to Initial Caps only?

I have an EXCEL worksheet with columns including first name and last name, in
all capital letters:

Column A is JOHN
Column B is SMITH

How can I change all the names so that, for example, JOHN becomes John and
SMITH becomes Smith? I will appreciate help.


 
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 do I change from all caps to proper case? Tom III Excel Discussion (Misc queries) 6 May 30th 07 05:54 AM
How do I change excell doc to all caps? princechopper Excel Discussion (Misc queries) 2 July 15th 05 12:31 AM
How to change case on a spreadsheet from Caps to Sentence? Mamacsee Excel Discussion (Misc queries) 1 July 5th 05 09:23 PM
How do I change from all caps to regular for existing data? CL Johnson Excel Discussion (Misc queries) 1 June 9th 05 04:49 AM
How do I change a spreadsheet from all caps to "Proper" dumbfounded Excel Discussion (Misc queries) 9 November 30th 04 08:22 PM


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

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

About Us

"It's about Microsoft Excel"