B
Bob
I know how to do a single entry in a column, but is it
possible to do an entire column at one time?
possible to do an entire column at one time?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Put the value in A1, press ctrl + shift & down arrow, press ctrl + d
to fill row do the same but instead of down arrow use right arrow and ctrl +
r
to fill row do the same but instead of down arrow use right arrow and ctrl +
r
C
Chip Pearson
Bob,
In a blank column next to your data, enter =PROPER(A1) where A1 is the first
cell of your data, and copy this down as far as you need to go. Then, copy
these cells and do a Paste Special / Values over the original data. Finally,
delete the column with the formulas.
In a blank column next to your data, enter =PROPER(A1) where A1 is the first
cell of your data, and copy this down as far as you need to go. Then, copy
these cells and do a Paste Special / Values over the original data. Finally,
delete the column with the formulas.
P
Peo Sjoblom
Apologize,
never read the subject.
never read the subject.
D
Dennis
Hers's a macro..
Sub ToProper()
Dim c As Range
Application.ScreenUpdating = False
For Each c In ActiveSheet.UsedRange
If c.HasFormula = False Then
c.Value = StrConv(c.Value, vbProperCase)
End If
Next c
Application.ScreenUpdating = True
End Sub
Dennis
========
Sub ToProper()
Dim c As Range
Application.ScreenUpdating = False
For Each c In ActiveSheet.UsedRange
If c.HasFormula = False Then
c.Value = StrConv(c.Value, vbProperCase)
End If
Next c
Application.ScreenUpdating = True
End Sub
Dennis
========