|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2009, 06:21 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
In excel can you change words from all caps to initial caps?
example instead of JOHNNY WALKER
I want it to be Johnny Walker. 
|
|
#2
May 13th, 2009, 06:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
Use PROPER(ref)
O2bardy wrote: example instead of JOHNNY WALKER I want it to be Johnny Walker.
|
|
#3
May 13th, 2009, 06:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
=PROPER(A1)
-- Gary''s Student - gsnu200852
|
|
#4
May 13th, 2009, 06:32 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
hi
assuming JOHNEY WALKER is in A2. =proper(A2) you can then copy the formula and paste special values in A2. or if you have a column of names to converte, you might add a helper column next to your name column. copy the formula down. then copy and paste special values on the helper column - delete the original column. regards "O2bardy" wrote: example instead of JOHNNY WALKER I want it to be Johnny Walker.
|
|
#5
May 13th, 2009, 08:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
Use =PROPER(A1)
Also just for information sake =UPPER(A1) to convert to Upper Case = LOWER(A1) to convert to Lower Case -- If this post helps click Yes --------------- Jacob Skaria "O2bardy" wrote: example instead of JOHNNY WALKER I want it to be Johnny Walker.
|
|
#6
May 7th, 2010, 05:32 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
"O2bardy" wrote: example instead of JOHNNY WALKER I want it to be Johnny Walker.
|
|
#7
May 7th, 2010, 01:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel can you change words from all caps to initial caps?
Hi
You can use =Proper(A1) HTH John "wmca1932" wrote in message ... "O2bardy" wrote: example instead of JOHNNY WALKER I want it to be Johnny Walker.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
