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