Excel 2000 capitalization help

D

Dan

We have a 1500 record spreadsheet that has mixed lower
and upper case in their cells. We would like to convert
all records to upper case automatically. We've tried the
formula Excel provides =Upper (cell to cell) without any
luck.

does anyone have any suggestions?

Thx

DAN
 
Top