Copying a string, capitalized

  • Thread starter Thread starter James C
  • Start date Start date
J

James C

I have a cell with a string in it, say AbcD.

I need a formula that will look at this cell and output it al
capitalized, e.g. ABCD

Thanks.

James
 
=UPPER(A1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a cell with a string in it, say AbcD.

I need a formula that will look at this cell and output it all
capitalized, e.g. ABCD

Thanks.

James C
 
Back
Top