How do I force all capital in a column of lower case names?

[Guest]

I read the help, but it doesn't tell me where to enter the formula.

 

[Guest]

If you do not have a blank column next to the mentioned column, then insert
one. Enter the formula in a cell adjacent to the cell you want to change,
and copy down. Then copy this column, go to the original column, select a
cel, right click and click on Paste Special, tick values. Delete the helper
column.

Iow, with you lower case data in Column E, click on Column F, if not empty,
and insert a column. F is then an empty column. Say your data starts in E2,
then in F2 enter =UPPER(E2). Move cursor to the bottom right hand corner of
the cell. When it changes, double click.

 

[Gord Dibben]

Enter the formula in a helper column.

Assuming column A is your data in lower case.

In B1 enter =UPPER(A1)

Double-click on the fill handle of B1 to copy down.

When happy, select column B and Edit>Paste Special(in place)>Values>OK>Esc.

Delete original column A


Gord Dibben MS Excel MVP

 

[JoAnn Paules [MVP]]

I just learned about this the other day. (I told you I was an Excel novice.)
That will save me a lot of time at work!

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[Gord Dibben]

Joanne

What saves even more work is to use VBA to convert all cells in a selection at
once.

No formulas hence no special pasting after.

Chip Pearson has an add-in at his site for doing this.

http://www.cpearson.com/excel/download.htm


Gord

 

[JoAnn Paules [MVP]]

I have to be careful about using VBA. One - I'm clueless about VBA. Two - my
coworkers know less than I do and it just complicates their life. I really
want them to decide that they want to hire me direct after my contract with
them expires so I try to keep things simple if they are going to be using my
files.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

 

[Bob Phillips]

create a lot of complicated macros that they don't understand, then they are
bound to re-hire you, so they can continue working <bg>

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

I have to be careful about using VBA. One - I'm clueless about VBA. Two -
my coworkers know less than I do and it just complicates their life. I
really want them to decide that they want to hire me direct after my
contract with them expires so I try to keep things simple if they are going
to be using my files.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Joanne

What saves even more work is to use VBA to convert all cells in a
selection at
once.

No formulas hence no special pasting after.

Chip Pearson has an add-in at his site for doing this.

http://www.cpearson.com/excel/download.htm


Gord

 

[JoAnn Paules [MVP]]

Murphy's Law tends to hit me a lot. That would probably come back to bite me
on my ............ um, workbook.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

create a lot of complicated macros that they don't understand, then they
are bound to re-hire you, so they can continue working <bg>

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

I have to be careful about using VBA. One - I'm clueless about VBA. Two -
my coworkers know less than I do and it just complicates their life. I
really want them to decide that they want to hire me direct after my
contract with them expires so I try to keep things simple if they are
going to be using my files.

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375

Joanne

What saves even more work is to use VBA to convert all cells in a
selection at
once.

No formulas hence no special pasting after.

Chip Pearson has an add-in at his site for doing this.

http://www.cpearson.com/excel/download.htm


Gord

On Wed, 14 Feb 2007 15:48:59 -0500, "JoAnn Paules [MVP]"

I just learned about this the other day. (I told you I was an Excel
novice.)
That will save me a lot of time at work!