Change Text Case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anyone know how to change the case (from all caps to lower case, or just first letter cap) without retyping all the text in a worksheet? Thanks!
 
a formula
=lower(a1)
=proper(a1)

--
Don Guillett
SalesAid Software
(e-mail address removed)
Chel said:
Anyone know how to change the case (from all caps to lower case, or just
Click to expand...
first letter cap) without retyping all the text in a worksheet? Thanks!
 
Chel,

You can use a macro like the following:

Sub ConvertCase()
Dim Rng As Range
For Each Rng In ActiveSheet.UsedRange.SpecialCells _
(xlCellTypeConstants, xlTextValues)
Rng.Value = StrConv(Rng.Text, vbProperCase) 'or vbLowerCase
or vbUpperCase
Next Rng
End Sub

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Chel said:
Anyone know how to change the case (from all caps to lower
Click to expand...
case, or just first letter cap) without retyping all the text in
a worksheet? Thanks!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change all text on Spread sheet 1
CHANGE ALL CAPS TO LOWER CASE WITHOUT TYPING 3
How do I convert addresses to all caps in Office 2007? 3
How do you change the Capitalization in an Excel Workbook? 7
change font from all capitals? 3
hOW DO i TURN TEXT INTO ALL CAPS? 2
Help with formatting columns. 1
Formatting cells to only upper case 5

Back
Top