I'm trying to do the same with a separate column of unlinked text, it isn't
working- and I end up with the following in the cell:
=My Text+UPPER(C3)
Bracketing as previous dosn't seem to work in this case??
Regards Graham

"Graham" wrote:

Perfect - You're a star-Thank you very much!!

"Jason Morin" wrote:

=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
.