Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Humbertt
 
Posts: n/a
Default Excel Capital Letters

I have a large worksheet with many columns, however, all the data is in lower
case letters. Is there a function or a way to change all the data into
capital letters? The data is demographic info only. Thanks inadvance.
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default Excel Capital Letters

In an adjacent column, enter the formula

=UPPER(A1)

and copy down as far as you need to go. You can the copy and
paste this data over your original data if desired.


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



"Humbertt" wrote in message
...
I have a large worksheet with many columns, however, all the
data is in lower
case letters. Is there a function or a way to change all the
data into
capital letters? The data is demographic info only. Thanks
inadvance.



  #3   Report Post  
Posted to microsoft.public.excel.misc
David McRitchie
 
Posts: n/a
Default Excel Capital Letters

H Humbert,
I expect you want to change those areas, probably whole columns at a time,
or other regions, in place. see
http://www.mvps.org/dmcritchie/excel/proper.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Humbertt" wrote in message ...
I have a large worksheet with many columns, however, all the data is in lower
case letters. Is there a function or a way to change all the data into
capital letters? The data is demographic info only. Thanks inadvance.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 49
Default Excel Capital Letters

Copy the following macro:

Sub Change_Case()
Dim ocell As Range
Dim Ans As String
Ans = Application.InputBox("Type in Letter" & vbCr & _
"(L)owercase, (U)ppercase, (S)entence, (T)itles ")
If Ans = "" Then Exit Sub
For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2)
Select Case UCase(Ans)
Case "L": ocell = LCase(ocell.Text)
Case "U": ocell = UCase(ocell.Text)
Case "S": ocell = UCase(Left(ocell.Text, 1)) & _
LCase(Right(ocell.Text, Len(ocell.Text) - 1))
Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text)
End Select
Next

End Sub


"Humbertt" wrote:

I have a large worksheet with many columns, however, all the data is in lower
case letters. Is there a function or a way to change all the data into
capital letters? The data is demographic info only. Thanks inadvance.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change letters at top of excel to custom headers painintheoffice Excel Worksheet Functions 1 July 27th 05 06:12 PM
Excel Cells doesn't have letters JustAsking Excel Discussion (Misc queries) 1 July 12th 05 10:27 AM
Auto change font to 'capital letters' Anthony Excel Worksheet Functions 3 February 12th 05 04:10 PM
How do i subscript multiple seperated letters in an excel cell? dunner Excel Discussion (Misc queries) 2 January 27th 05 08:42 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 12:32 PM


All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"