F Fred Smith Mar 21, 2010 #2 In an adjacent column, use the Upper function, as in: =upper(a1) You can then convert this to values, and delete the original. Regards, Fred
In an adjacent column, use the Upper function, as in: =upper(a1) You can then convert this to values, and delete the original. Regards, Fred