| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change to all caps
I have an excel spreadsheet in which there is a column that contains names. I
need to change all the names in the column to ALL CAPS. I searched elsewhere for a formula but it didnt work. Any ideas? -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change to all caps
Hi,
=UPPER(A1) Drag down and then if you want to copy and paste special - paste values back over the original column Mike "NAS" wrote: I have an excel spreadsheet in which there is a column that contains names. I need to change all the names in the column to ALL CAPS. I searched elsewhere for a formula but it didnt work. Any ideas? -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change to all caps
The formula
=Upper(A1) will convert the text in cell A1 to all caps. -- HTH... Jim Thomlinson "NAS" wrote: I have an excel spreadsheet in which there is a column that contains names. I need to change all the names in the column to ALL CAPS. I searched elsewhere for a formula but it didnt work. Any ideas? -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change to all caps
Thank you both for your help. I also found a macro that will work too.
-- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". "Jim Thomlinson" wrote: The formula =Upper(A1) will convert the text in cell A1 to all caps. -- HTH... Jim Thomlinson "NAS" wrote: I have an excel spreadsheet in which there is a column that contains names. I need to change all the names in the column to ALL CAPS. I searched elsewhere for a formula but it didnt work. Any ideas? -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change to all caps
Hi,
Glad that helped but beware of the macro, there's a lot of bad ones posted that will wipe out any formula you have in the range by changing them to values. Mike "NAS" wrote: Thank you both for your help. I also found a macro that will work too. -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". "Jim Thomlinson" wrote: The formula =Upper(A1) will convert the text in cell A1 to all caps. -- HTH... Jim Thomlinson "NAS" wrote: I have an excel spreadsheet in which there is a column that contains names. I need to change all the names in the column to ALL CAPS. I searched elsewhere for a formula but it didnt work. Any ideas? -- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel can you change words from all caps to initial caps? | Excel Discussion (Misc queries) | |||
| How do I change from all caps to proper case? | Excel Discussion (Misc queries) | |||
| How to change ALL CAPS to Initial Caps only? | Excel Worksheet Functions | |||
| How do I change excell doc to all caps? | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
Linear Mode
