Converting to Uppercase by selecting a Column?

[darpa01]

Hi,

How can I make the columns in the RECORDS TAB in column A in the attached worksheet to convert to all UPPER CASE letters without having to re-enter each word by using the CAPS LOCK key?

Thanks in advance.

[ConneXionLost]

Hi darpa01,

On another sheet, use the UPPER function to look at column A, then copy & paste > Special > Values.

Cheers,

[darpa01]

Thanks.

But I tried the UPPER function for my time stamp for Apr, but does not work. So how can I make the Apr in the attached xls sheet (in the Records tab) to make the Month all uppercase?

It seems that this does not work since I have the =NOW() in that cell.

Please explain the steps for making the Month (in my time stamp) uppercase?

Thx again.

[VBA Noob]

Maybe you could use

=UPPER(TEXT(NOW(),"HH:MM:SS DDMMMYY"))

VBA Noob

[darpa01]

Oh....your great!!!! thanks.

Now, what if I want to use the TIME ZONE function like this to the UPPER function you gave me?

I know the Time Zone firmula which is this here
=NOW()-TIME(1,0,0)

But how can I use this with the UPPER function formual you just gave me above?

Suppose my time zone has an OFFSET of -1 (see above) from ZULU or UTC, how can I use this with the UPPER FUNCTON you just gave?

Thx.

[ConneXionLost]

Just modify VBA Noob's formula like this:

Please Login or Register  to view this content.

Cheers,