Assuming the column of data you want to change is in Column Astarting from
A1:
1 Insert a new Column B clicking into the 'B' of the column and selecting:
Insert Columns

2 Enter in B2 then formula:
=UPPER(A1)
this will put the contents of A1 in B1 in upper case

3 Select cell B1 and hover the cursor over the bottom right-hand corner of
cell B1, (where there is a small black square). When it changes from a big
white cross into black cross-hairs double left-click and the foruma will be
copied down Column B as far as the data goes in Column A.

4 With the new data still selected, right-click and select copy then select
cell A1 and right-click and select Paste Special Values. This will enter
the upper case data into Column A

5 Finally select and delete the helper Column B



--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"singmusik04" wrote in message
...
I am highlighting a column. I assume there must be a way to capitalize ALL
text in the column without actually doing it manually.....Please reply
like I
am a 5 year old and tell EXACTLY where to go from the beginning to the
end....I am very new at this and have been at it for hours...again please
be
very basic with me....I THANK YOU!