How do I change a column in excel that has names typed in each cell and
change those name from lower case to upper case without retyping the names.

See response in other group. Please don't multipost.

Regards,
Fred.

"FOP38" wrote in message
...
How do I change a column in excel that has names typed in each cell and
change those name from lower case to upper case without retyping the
names.

Right click the tab for the worksheet containing your names... this will
take you into the Visual Basic editor. Next, assuming the Immediate window
is not already displayed, key in Ctrl+G. Then copy/paste this statement into
the Immediate window...

For X = 1 to 1000: Cells(X, "B").Value = UCase(Cells(X, "B").Value): Next

Change the 1000 to a number equal to the row number for the last name in
your column and change the two occurrences of "B" to the letter (in quotes)
of the column containing your names With your cursor is still on this line,
press the Enter key. When you go back to the worksheet, all the names will
be capitalized.

Rick


"FOP38" wrote in message
...
How do I change a column in excel that has names typed in each cell and
change those name from lower case to upper case without retyping the
names.

I see you multi-posted your question to more than one newsgroup. Please read
the following...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick


"FOP38" wrote in message
...
How do I change a column in excel that has names typed in each cell and
change those name from lower case to upper case without retyping the
names.

See Dave Curtis' response... that is a case in point (Fred Smith suggested
his posted method over in the other thread)!

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
I see you multi-posted your question to more than one newsgroup. Please
read the following...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick


"FOP38" wrote in message
...
How do I change a column in excel that has names typed in each cell and
change those name from lower case to upper case without retyping the
names.

Hi,

use the formula

=UPPER(A1)

or whatever is your cell reference, drag down, and then do a copy, paste
special, values.

Dave

url:http://www.ureader.com/msg/104234510.aspx