How to do I change text to caps.

[EVRPAGING]

Hello,

I have a column with names in it. The names are in lower case. I wan
to change all letter in the name to capital letters. How can I do thi
without having to type all the names again.

Thank you for your help

 

[Michael Malinsky]

Assuming your names are in column A, in column B, use:

=UPPER(A1)

You can also capitalize only the first letter of each word by using:

=PROPER(A1)

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Judy Freed]

I believe you want the UPPER function. See this documentation which
explains PROPER, UPPER AND LOWER.

http://www.uncc.edu/sysdev/howtos/excel/the proper function.htm


Judy Freed
Systems Development
UNC Charlotte

 

[Ron de Bruin]

Hi EVRPAGING

See this webpages
http://www.mvps.org/dmcritchie/excel/proper.htm
Or
http://www.cpearson.com/excel/case.htm

Here is a macro for changing the cells with text in the selection

Sub Uppercase_macro()
Dim selectie As Range
Dim cel As Range
On Error Resume Next
Set selectie = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
If selectie Is Nothing Then Exit Sub
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
For Each cel In selectie
cel.Value = UCase(cel.Value)
Next cel
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub

 

[Mark Rosenkrantz]

Use Application.Proper to enter text were the first letter is a capital.

tbText.Value = Application.Proper(tbText.Value)


--
Meer Excel ? www.rosenkrantz.nl of (e-mail address removed)
-------------------------------------------------------------------
Rosenkrantz Spreadsheet Solutions
Witkopeend 24
1423 SN Uithoorn
Nederland
Tel : 0297-527511

 

[EVRPAGING]

or say I have a word in lower case and I want to change to capita
letters, how do I do this without having to type the word again

 

[Allan Koodray]

Use the function =Upper(A1) (Where A1 is the cell you
wish to convert) in cell B1, copy the column then Edit ->
Paste Specail -> Value the cells from column B to column
A. You may also consider using =Proper(A1) which would
capitalize the first letter of each name/word.

Allan

 

[Rollin_Again]

Let's assume the list of names you need capitalized is in Column A. I
the first name is in cell A1, type the following formula in cel
B1-------> *=Upper(A1)* Now copy the fomula from cell B1 an
paste it into all cells in your helper column. The only other way t
accomplish what you want without a helper column is to use VBA.


Rolli

 

[papou]

Hi
How about a macro?
(Select cells prior to running the macro)
Sub PutInCaps()
For Each c In Selection.Cells
c.Value = Application.WorksheetFunction.Proper(c.Value)
Next c
End Sub

HTH
Cordially
Pascal

 

[mzehr]

Hi,
Try using a helper column with the formula =Upper(a1) put
in the helper column, and copy it down. See also:
http://www.mvps.org/dmcritchie/excel/proper.htm
HTH

 

[EVRPAGING]

Thank you all for your help. I was able to format my spreadsheet wit
your suggestions. Thanks for all your help!!