Excel Cell Format

  AndySD 16:18 20 May 2005

Is there a way to force excel to capitalise text in certain cell?

  Yoda Knight 16:41 20 May 2005

Using VBA, yes....

  joncuk 16:41 20 May 2005

I know how to convert text to capitals if that is what you want.
Click on the cell you want Caps in then
you search through the functions for "UPPER"
press enter.

anything enterd in lower case will convert to caps.
You can also do the reverse by serching for "LOWER". this will convert caps to lower case

john cooke

  Eric10 17:14 20 May 2005

You could format the cell to Text and use a font that is capitals only such as "Copperplate Gothic Light". The Preview area in the Fonts dialogue shows an example of the selected font so you can find a suitable one.

  lotvic 19:24 20 May 2005

bookmarked for reference

  daba 20:26 20 May 2005

If "my text" is in A1

then in B1


results in B1 "My Text"

  VoG II 22:10 20 May 2005

Assume that the cell that you want to be in uppercase is A1. Right click the sheet tab, select View Code. Delete whatever is shown and enter the following:

Private Sub worksheet_change(ByVal target As Excel.Range)

If target.Address = "$A$1" Then

target.Value = UCase(target.Value)

End If

End Sub

  AndySD 22:28 22 May 2005

Cheers VOG

  AndySD 22:30 22 May 2005

Cheers VOG

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?