Array case conversion

[bonk1954]

I definitely need help-
I have a long list (very long) of movie title which need to be converted from lower to upper case (entire titles). I have been able to convert one title per try but have not yet been able to convert a list of titles. No matter what form I enter for an array formula the Excel response is #VALUE!
I have tried, I think, every possible formula variation, e.g., =upper(j2)j10)
=upper(J2:J10), =upper(J10)*(J2), on and on ad infintum.
can anyone HELP ol' Grog???

[shg]

Why use an array formula? Why not just use =UPPER(J2) and copy down?

[MarvinP]

Hi bonk1954 and welcome to th forum,

To better understand your question (it seems simple enough) it would help if we had a sample workbook

To attach a sample, click on the "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message area. BTW - I like Proper() better than Upper().

[snb]

If this needs to be done only once:

Sub snb()
    [J1:J10] = [index(UPPER(J1:J10),)]
End Sub