changing case in MS excel and Adding bullets

[mgmxls]

Does any one know about any VB code that can be inserted in MS Excel or a ready utility so as to enable users to change case of letters from Title case to Uppercase or to Lowercase?

Like Shift+F3 in MS Word.

On the same lines I wonder how one can add bullets in a cell of excel sheet exactly like what we do in MS word.

I would be glad if someone can provide any answers to these points.

_________________
MgM

[ This Message was edited by: mgmxls on 2002-05-16 02:50 ]

[dimrod]

On 2002-05-16 02:49, mgmxls wrote:
Does any one know about any VB code that can be inserted in MS Excel or a ready utility so as to enable users to change case of letters from Title case to Uppercase or to Lowercase?

Like Shift+F3 in MS Word.

On the same lines I wonder how one can add bullets in a cell of excel sheet exactly like what we do in MS word.

I would be glad if someone can provide any answers to these points.

_________________
MgM

[ This Message was edited by: mgmxls on 2002-05-16 02:50 ]

Converting to Upper or Lower case has been covered recently on this board - a search should take you to the appropriate thread(s).

Adding bullets has probably also been covered at some stage, but if not try this :-

Sub bullet()
Dim bullet As String, cell As Range
bullet = Chr(149) & Chr(32)
For Each cell In Selection
If Left(cell.Value, Len(bullet)) <> bullet Then cell.Value = bullet & cell.Value
Next
End Sub