=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to change Normal Text on one worksheet to CAPITAL
TEXT on a second
sheet to which it is linked. I have been able to do this
by adding an
additional column to my second sheet, using the "UPPER"
function and copying
all the data to the adjacent column. Can I apply this
funtion directly to my
linked text ? I get assorted error messages when I try
this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name
of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks
.