Copying a string, capitalized

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
 
R

RagDyeR

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting the last word from a string. 2
Word isn't capitalizing the first word of each sentence 2
SUM Char 9
Copy first few letters from a cell 9
Help with "IF" function 1
5th Char in a cell 3
counting no. of times a character occurs in a cell 3
Find position number of third space 6

Top