Formula to Capitalize all Text in colums

[JERRY_MD]

Hello

I am searching for a formula that can capitalize all text in MS Excel columns? I would greatly appreciate any assistance.

Thank you

 

[tanny81]

Hi,

Try =upper(cell reference).

Regards,

 

[VoG]

Hello and welcome to MrExcel.

Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste into the white space on the right

Sub ToCaps()
Dim c As Range
For Each c In Selection
    c.Value = UCase(c.Value)
Next c
End Sub

Press ALT + Q to return to your sheet, select the range to capitalise then Tools > Macro > Macros, click on ToCaps then click the Run button.

 

[JERRY_MD]

Thank you