How to change mixed case to upper case in Excel for all cells
You're welcome.
--
Kevin Vaughn
"WordAlone Network" wrote:
Thanks - that will work just fine!
Anne
"Kevin Vaughn" wrote:
You could use a helper column and the formula =upper(a1) copied down.
If you wanted, you could then copy - paste special values back over the
originals and get rid of the helper column.
--
Kevin Vaughn
"WordAlone Network" wrote:
I need to change name and address from mixed case to uppercase in the cells
on my Excel spreadsheet - is there a way to do this without retyping
everything?
|