Using Upper Case Formula for Multiple Cells
Your original data entry will be in whatever case it is entererd in. In an
adjacent cell just add the formula =Upper(??) to reformat the data entry top
upper case. I have seen macros and validation routines to force upper case
but I kinda like the simple formula method described above...
--
HTH...
Jim Thomlinson
"Elle" wrote:
I want a range of cells to atomatically be in upper case with out having to
change the case on my keyboard.
Can I apply the Upper= formula to a column of cells?
|