Software

Ask something
Discussion Locked

Excel 97 Text Conversion

0 helpful
1 reply

by stanblois

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
MS Word has a function for converting text to/from upper/lower case. Does Excel 97 have a similar method?

1 reply

by dklippert

You could create an empty column and then use =UPPER(), =LOWER(), or =PROPER().
Another way is to put an icon on the toolbar and assign this macro to it. The macro will toggle the case of the selection.

Sub SwitchCase()

' macro by Chip Pearson

Static N As Long
With ActiveCell
.Value = StrConv(.Text, N + 1)
End With
N = (N + 1) Mod 3
End Sub

This discussion is closed to new replies.