Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Add a column next to the first name. The in that column use the formula
=Proper(A1), A1 being the cell that contains the first name. Then copy that cell down. Do the same for Last Names. Then keep the cell values, and delete the original set. Should be an easier way I think (selecting the entire column and using conditional formatting) but MS hasn't seen fit to do this yet. -- John C. Harris, MPA JCZ Consulting Services, LLC "Robert Judge" wrote in message ... 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. |
#3
|
|||
|
|||
check out Proper() in help
"Robert Judge" wrote: 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. |
#4
|
|||
|
|||
select the text you want to change. press Shift F3. "bj" wrote: check out Proper() in help "Robert Judge" wrote: 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. |
#5
|
|||
|
|||
On Fri, 23 Sep 2005 23:33:02 -0700, "Reba"
wrote: select the text you want to change. press Shift F3. "bj" wrote: check out Proper() in help "Robert Judge" wrote: 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. In say C1 =Proper(A1) Copy down col C&D as necessary. When you've finished copy columns C&D and Paste Special Values back in cols A & B HTH HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#6
|
|||
|
|||
I'm afraid you are think of Word. In Excel Shift+F3 is used to insert a
formula. If you're already in Edit mode, selecting characters in the formula bar and pressing SHIFT+F3 does nothing (at least in XL2003). On Fri, 23 Sep 2005 23:33:02 -0700, "Reba" wrote: select the text you want to change. press Shift F3. "bj" wrote: check out Proper() in help "Robert Judge" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
How do I change excell doc to all caps? | Excel Discussion (Misc queries) | |||
How to change case on a spreadsheet from Caps to Sentence? | Excel Discussion (Misc queries) | |||
How do I change from all caps to regular for existing data? | Excel Discussion (Misc queries) | |||
How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) |