UPPER text function

[Guest]

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

 

[Jason Morin]

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

 

[Guest]

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

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

 

[Guest]

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

 

[Guest]

Hi

Try something like
=MyText&UPPER(C3) eg ="Abcdef ghi jk"&UPPER(C3)