D6=upper(A6)
highlight D6
drag to E6
highlight D6:E6
drag to E11999


On Mar 3, 3:22*pm, "ordnance1" wrote:
My original post seems to have disappeared so here is a repeat.

I have to clean up a spreadsheet by converting the text in cells A6:B11999
to uppercase text. These cells contain text only. Is there a quick way to
accomplish this? *