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".

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".

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".

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".

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".