In article ,
"Keith (Southend)" writes:
Not sure what to put in the 'text' quotes as every word in the list is
different?

Thanks Keith (Southend)

Syntax

PROPER(text)

Text is text enclosed in quotation marks, a formula that returns
text, or a reference to a cell containing the text you want to
partially capitalize.

You want to use the last of these options. So if the text is in A1, say,
then in cell B1 (or whatever the next unused cell in the row is) you
might put =proper(A1). Then if your list items are in column A (A1, A2
etc) then you can just drag your formula in B1 down column B and it will
automatically adjust so that in B2 you get =proper(A2) and so on. (It
will work just as well with rows as with columns, if that is how your
list of text items is laid out.)
--
John Hall
"The power of accurate observation is commonly called cynicism
by those who have not got it."
George Bernard Shaw