capitalising names

  • Thread starter Thread starter Graham Warren
  • Start date Start date
G

Graham Warren

I have a list of students names (about 300) all in lower case: ie harriett,
alan, michael. Is there a (quick) way of capitalising the first letter so
that it reads Harriett, Alan, Michael? I really don't want to have to
re-type the whole lot.

Many thanks.
 
Use a help column and a formula like

=PROPER(A1)

copy down as long as needed, copy the new list and paste special as values
over the old list,
delete the help column
 
Hi
use the following macro:
Sub ConvertToProper()
Dim Rng As Range
For Each Rng In Selection.Cells
If Rng.HasFormula = False Then
Rng.Value = application.worksheetfunction. _
proper(Rng.Value)
End If
Next Rng
End Sub
 
The only way I can think of is to do a find and replace
for each letter that a first name begins with. For
example: you would find all h* and replace with H

This would make all the first names that start with h to
turn to H, but you'd have to do it for each letter?
 
You can see the other solutions. Yours could/would change, eventually, every
letter of every name to upper case.
 
Assuming your list is in column A, choose an empty
column, say column C. In cell C1 type =Proper(a1)then
drag this down to extent of your list i.e. 300 rows. This
will capitalize all your names.

Then select all cells in column C, right click, copy,
goto A1 choose Paste Special, Values, this will copy all
your capilazed names back into column A. Now delete
column C, job done.
 
Back
Top