P
Pete_UK
You can enter this formula in a blank cell:
=UPPER(A1)
to convert whatever is in A1 to upper case, and then copy the formula
down the column for as many entries as there are in column A. You can
do this for other columns as necessary and then fix the values using
<copy> | Edit | Paste Special | Values (check) then OK and <Esc> and
then you can delete the original columns.
Hope this helps.
Pete
=UPPER(A1)
to convert whatever is in A1 to upper case, and then copy the formula
down the column for as many entries as there are in column A. You can
do this for other columns as necessary and then fix the values using
<copy> | Edit | Paste Special | Values (check) then OK and <Esc> and
then you can delete the original columns.
Hope this helps.
Pete