How can I change the text from lower case to upper case in an Excel work book
and vice versa?
How can I change the text from lower case to upper case in an Excel work book
and vice versa?
To get the value in an other cell
=UPPER(A1)
If you want to do a whole sheet, with VBA
For each cell In Activesheet.UsedRange
If Not cell.HasFormula Then
cell.Value = UCase(Cell.Value)
End If
Next cell
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"dave01968" <[email protected]> wrote in message
news:[email protected]...
> How can I change the text from lower case to upper case in an Excel work
book
> and vice versa?
The lower case equivalents are LOWER and LCase.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"dave01968" <[email protected]> wrote in message
news:[email protected]...
> How can I change the text from lower case to upper case in an Excel work
book
> and vice versa?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks