How can I convert text to all lowercase?

How can I convert text to all lowercase?

I know that I can use the Format menu to convert a block of text to all
uppercase, but is there any way to convert it to lowercase?

If not with Excel, how about Word, DOS, any other way.

I'm using Excel 7.0 (Office 95).
Thanks in advance!

0
12/7/2003 8:58:12 PM
excel.misc 78881 articles. 5 followers. Follow

4 Replies
537 Views

Similar Articles

[PageSpeed] 36

Take a look at David McRitchie's Lower() Macro (I believe it will 
work in XL7):

    http://www.mvps.org/dmcritchie/excel/proper.htm#lower

In article <20031207155812.23043.00000330@mb-m27.aol.com>,
 hbyardsale@aol.comnetorg (HBYardSale) wrote:

> How can I convert text to all lowercase?
> 
> I know that I can use the Format menu to convert a block of text to all
> uppercase, but is there any way to convert it to lowercase?
> 
> If not with Excel, how about Word, DOS, any other way.
> 
> I'm using Excel 7.0 (Office 95).
> Thanks in advance!
>
0
jemcgimpsey (6723)
12/7/2003 9:11:00 PM
Don't have Excel 7 so can't test it on that, but try the following.  Not the
most efficient way of doing it, but I'm not sure what Excel 7 will support:-

This will do everything on the sheet, but if you prefer to do just a selection,
just change the

For Each cell In ActiveSheet.UsedRange

to

For Each cell In Selection

------------------------------------------------------------

Sub MakeLowercase()

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

 For Each cell In ActiveSheet.UsedRange
    If cell.HasFormula = False Then
      cell.Value = LCase(cell.Value)
    End If
 Next cell

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic

End Sub

-- 
Regards
           Ken.......................    Microsoft MVP - Excel
                  Sys Spec - Win XP Pro /  XL 00/02/03

----------------------------------------------------------------------------
Newsgroups - Where you really can get a free lunch!!
----------------------------------------------------------------------------



"HBYardSale" <hbyardsale@aol.comnetorg> wrote in message
news:20031207155812.23043.00000330@mb-m27.aol.com...
> How can I convert text to all lowercase?
>
> I know that I can use the Format menu to convert a block of text to all
> uppercase, but is there any way to convert it to lowercase?
>
> If not with Excel, how about Word, DOS, any other way.
>
> I'm using Excel 7.0 (Office 95).
> Thanks in advance!
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003


0
ken.wright (2489)
12/7/2003 9:14:20 PM
Word has that built in, under format>Change Case,
maybe that is what you were thinking of? Excel does not have that built in,
you either have to use
a help column and a formula

=UPPER(A2)

copy down, copy and paste special as values over the old values, delete help
column

or you could run a macro like the one below

Sub UpCase()
Application.DisplayAlerts = False
  Dim R As Range
  For Each R In Selection.Cells
    If R.HasFormula Then
      R.Formula = "=UPPER(" & Mid(R.Formula, 2) & ")"
    Else
      R.Value = UCase(R.Value)
    End If
  Next
  Application.DisplayAlerts = True
End Sub


press Alt + F11, click insert module and paste in the above,
press At + Q to close the VBE, select the text and press Alt + F8 to run the
macro

-- 

Regards,

Peo Sjoblom

"HBYardSale" <hbyardsale@aol.comnetorg> wrote in message
news:20031207155812.23043.00000330@mb-m27.aol.com...
> How can I convert text to all lowercase?
>
> I know that I can use the Format menu to convert a block of text to all
> uppercase, but is there any way to convert it to lowercase?
>
> If not with Excel, how about Word, DOS, any other way.
>
> I'm using Excel 7.0 (Office 95).
> Thanks in advance!
>


0
terre081 (3244)
12/7/2003 9:15:46 PM
Oops!

Sub LowCase()
Application.DisplayAlerts = False
  Dim R As Range
  For Each R In Selection.Cells
    If R.HasFormula Then
      R.Formula = "=LOWER(" & Mid(R.Formula, 2) & ")"
    Else
      R.Value = LCase(R.Value)
    End If
  Next
  Application.DisplayAlerts = True
End Sub

-- 

Regards,

Peo Sjoblom

"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uzXvHdQvDHA.1088@tk2msftngp13.phx.gbl...
> Word has that built in, under format>Change Case,
> maybe that is what you were thinking of? Excel does not have that built
in,
> you either have to use
> a help column and a formula
>
> =UPPER(A2)
>
> copy down, copy and paste special as values over the old values, delete
help
> column
>
> or you could run a macro like the one below
>
> Sub UpCase()
> Application.DisplayAlerts = False
>   Dim R As Range
>   For Each R In Selection.Cells
>     If R.HasFormula Then
>       R.Formula = "=UPPER(" & Mid(R.Formula, 2) & ")"
>     Else
>       R.Value = UCase(R.Value)
>     End If
>   Next
>   Application.DisplayAlerts = True
> End Sub
>
>
> press Alt + F11, click insert module and paste in the above,
> press At + Q to close the VBE, select the text and press Alt + F8 to run
the
> macro
>
> -- 
>
> Regards,
>
> Peo Sjoblom
>
> "HBYardSale" <hbyardsale@aol.comnetorg> wrote in message
> news:20031207155812.23043.00000330@mb-m27.aol.com...
> > How can I convert text to all lowercase?
> >
> > I know that I can use the Format menu to convert a block of text to all
> > uppercase, but is there any way to convert it to lowercase?
> >
> > If not with Excel, how about Word, DOS, any other way.
> >
> > I'm using Excel 7.0 (Office 95).
> > Thanks in advance!
> >
>
>


0
terre081 (3244)
12/7/2003 9:29:54 PM
Reply:

Similar Artilces:

Remove space and trailing text from number
Hi ng Using xl xp pro. Receive text file wish to convert to xl Some data comes in like this: 12 oz Would like to trim " oz" w/o quotes So all I'm left with is 12 Here's my formula: =IF(ISNUMBER(A3),A3,(VALUE(LEFT(A3,FIND(" ",A3)-1)))) Works fine. However other data comes in this format: 12+z How could I re-work my formula to take care of either condition Remaining value beginning from left of string could be any number of digits Also: If col a contains text I receive #value! error I take care of this with =IF(ISNUMBER($F1037),$F1037,1) But it would be more el...

Aligning text to right margin using right tab
Hi, I am trying to create a heading in a Publisher 2003 document, the first part of which starts flush with the left margin and the second part of which ends flush with the right margin. I have done this before in Word using left aligned text, with a right tab stop at the right margin. However, this doesn't seem to work in Publisher - the tab seemingly has to be in indented from the actual margin position, otherwise the text wraps onto the next line. Am I doing something wrong, or have I missed something? I don't really want to create a separate text box to achieve this, as ...

Can I set a filter on the source data for a pivot table
I want to exclude certain records from a pivot table... i.e., Buy/Sell Quantity B 5,000,000.00 S 5,000,000.00 B 1,000,000.00 B 10,000,000.00 S 7,000,000.00 B 500,000,000.00 S 200,000,000.00 Only inlcude "B" records. Can a pivot table be set up to filter? Thanks ChrisP You could add the Buy/Sell field to the page area of the pivot table, and select B from the dropdown list there. ChrisP wrote: > I want to exclude certain records from a pivot table... i.e., > > Buy/Sell Quantity > B 5,000,000.00 > S 5,000,000.00 > B 1,000,000.00 > B 10,000,000.00 &...

How to convert DVD to ipad and transfer/sync DVD to ipad
Thanks to its bigger screen and landscape orientation, the new iPad is a much better device to watch movies on than any previous version of the iPod and iPhone. Now there are many people curious about how to get their DVD movies into a format that the iPad can play. The following tutorial is going to show you how to convert DVDs to iPad compatible video/audio files and watch DVD movies on 'Apple iPad' (http://www.ifunia.com/ipad-column/index.html). At first, you need to know the formats Apple iPad can play. IPAD SUPPORTED VIDEO AND AUDIO FORMATS VIDEO/MOVIE FORMATS[/B]: ...

Concatenate text & number cell
Hi all, I need to concatenate a word and a number cell. eg, Concatenate("Limit = $",A1) where A1 = $100,000. It shows up like this: "Limit = $100000". However I want the number to format with the comma between the thousand, ie. "Limit = $100,000" Does any one know how to do this. Thanks in advance. regards, John. one way: ="Limit = " & TEXT(A1,"$#,##0") In article <2285c01c45d99$ff299070$a301280a@phx.gbl>, "John" <anonymous@discussions.microsoft.com> wrote: > Hi all, > I need to concatenate a wo...

How can I use ClassWizard in Visual C++ 2005 ?
Any help will be appreciated.Thanks! View->ClassView -- Vipin Aravind http://www.explorewindows.com "howen" <howen@actions-semi.com> wrote in message news:e87ZX6MQGHA.2108@TK2MSFTNGP10.phx.gbl... > Any help will be appreciated.Thanks! > > What used to be ClassWizard has now just been integrated into the right click menus. For example, if you open a dialog and right click on a control, you'll see items for most of the ClassWizard functionality. Unfortunately, the traditional ClassWizard was removed in version 7 in difference to conforming the VS ...

I can recibe but cannot send email
I have problem with outlook I cannot send email but Ican recibe In news:FAC7144A-DB2D-47B3-BAAB-8CE3DB06FB1C@microsoft.com, rudito <rudito@discussions.microsoft.com> typed: > I have problem with outlook I cannot send email but Ican recibe Hi - When you post in here, always include your version, SP level, and mode (if applicable) of Outlook - you can find this information in Help | About. Also include the type of mail account(s) you use and any other pertinent details. Be sure to put a consise summary of your question in the subject line, and the full details in the body of yo...

Convert text to number
Hi guys, I receive a workbook that contains unformatted text and need to wor with numbers. I have MS Excel 2000 and can not convert text to number Just do not know how. P.S. Select Range - Format to number does not work. Thanks a lot to everybody who has any advice. Irina -- Irin ----------------------------------------------------------------------- Irina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=868 View this thread: http://www.excelforum.com/showthread.php?threadid=26345 Hi what type of text does your range contain. Could you post an example? ...

how to store text in a cedit window to file
how do you store the text from a Cedit window, or any CString, to file as text that can be viewable by other applications such as notepad? CString s; c_MyEditControl.GetWindowText(s); CStdioFile f; if(!f.Open(_T("Name.of.your.choice.txt"), CFile::modeCreate | CFile::modeWrite))) return FALSE; // or other appropriate error action f.WriteString(s); f.Close(); return TRUE; // or other appropriate success action joe On Mon, 4 Aug 2008 16:33:30 -0700, "Nick Schultz" <nick.schultz@flir.com> wrote: >how do you store the text from a Cedit window, or any C...

Cells formated as text do not always display properly
I am using Office XP and Windows XP. I have formatted a column of cells as text and word wrap is checked, horizontal alignment is Left, Vertical alignment is Bottom. I use these cells to type a short narrative. The problem is some of the cells will not display properly, all they show is ######. The row height will expand to hold the text sometimes but not always but it will still only show ######## instead of the text I typed. If I change the cell type to General all the text is visible. This does not happed to evey cell, only some of them. I can type several rows of data with a narr...

place cursor in a specified text box in a Word form
Hello, I have a Word form developed in vba and when a specific textbox is empty a message box appears to tell the user to enter some data before they can proceed. When they click ok to continue the cursor places itself in textbox4 on the form but I want it to be in the box they have left empty (in this case textbox5). I have used the SetFocus method but that doesn't seem to do anything, it still ends up in textbox4. Any ideas anyone? Thanks. What sort of a form? If a protected form see http://www.gmayor.com/formfieldmacros.htm -- <>>< ><<> >...

convert number into corrseponding text
Hi, I would like to know if there is a way to display text on the corresponding number. eg. I type 530,000 and it would show me Five hundred and thirty thousand Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH RP (remove nothere from the email address if mailing direct) "mustafa" <mustafa@discussions.microsoft.com> wrote in message news:6A5B7274-959A-4E78-B9B9-D8A31D23D3D1@microsoft.com... > Hi, > > I would like to know if there is a way to display text on the corresponding > number. > > eg. > I type 530,000 > and it ...

Text Box 05-21-10
I have the following event procedure on a text box: Private Sub txtNotesOnTransaction_BeforeUpdate(Cancel As Integer) Debug.Print "User: " & CurrentUser() & " " & Me!txtNotesOnTransaction End Sub It is suppose to stamp the user name in the text box but it does not work. Any suggestions? Thanks PJ - The debug.print will just display (in the immediate window of the code pane) the name and the Notes. If you want the notes saved with the name, do this: Me!txtNotesOnTransaction = "User: " & CurrentUser() & " " &a...

formula is displayed as literal text instead of formula result
I have been having trouble frequently with formulas appearing as litera text in the cell instead of a formula with a result. Does anyone have any suggestions as to what I may be doing wrong -- carlossalt ----------------------------------------------------------------------- carlossaltz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2420 View this thread: http://www.excelforum.com/showthread.php?threadid=38396 The cell you're working in is probably formatted as text. Try changing the format to something appropriate. If you are entering the formula cor...

Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key message. Here is what the message looks like. HKEY_LOCAL_MACHINE/SOFTWARE/MICROSOFT/WINDOWS/CURRENT VERSION/RUN/OPTIONAL COMPONENTS/MSFS Help! Have you tried completely Uninstalling it and re installing it? Russ -- Russell Grover - SBITS.Biz [SBS-MVP] Microsoft Gold Certified Partner Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Second Opinion $15 - www.PersonalITConsultant.com Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com &q...

I can't see field From:
Im have a user A that should send emails with "send From:" user B. But user A don't see field From on address field and on View/From to, and his can't add it. How could i make it visible? Wojtek I am using Outlook 2003 with Word as my e-mail editor and when I open a new message I can go to the drop down arrow next to Options on the menu bar and select From. I hope this information is helpful. Robert Findlay Partner Technical Lead -- BizApps Microsoft Technical Support for Platforms and Business Applications ...

How can I easily update formulas that include new rows?
I have a worksheet that I use to update league baseball game stats on a daily basis. Each day as many as 13 new rows are added to the bottom. I then have to go to the top of 10 separate columns one at a time to update SUM formulas so that they will include the new rows. For example, Col C may have a formula at the top of the col that reads: =SUM(C4:C300). After the addition of say 9 rows, I have to manually change the formula to read: =SUM(C4:C309). Is there a way to type that 309 in a blank cell just once and have all the SUM formulas refer to it? TIA for your help. OldKenGoat Hi ...

Can't View Calendar Events
We recently upgraded from Exchange 5.5 to Exchange 2000. One of our employees can't view events on one of the calendars we have set up for all employees to use. I have blown away her mail profile and re-installed Outlook her machine, but the problem remains. Can anyone offer suggestions? Exchange is running on a 2000 Server box and the client machine is running XP sp1. Thanks Did you check the permissions on the PF calendar folder? David wrote: > We recently upgraded from Exchange 5.5 to Exchange 2000. > One of our employees can't view events on one of the > calen...

Can CRM Share an Exchange Server
Hello, We installed CRM on W2K3 server with Exchange 2003 running on it. We are assuming that this configuration will be OK given that they are supporting an install on SBS. Howerver, we had trouble adding users so we uninstalled. Upon reinstalling we keep getting a failure during provisioning. Can anyone shed any light on 1. Is it Ok to put this think on the Exchange Box? The exchange box only supports 10 users, but it is P4 Dual 2.8 Dell 2850 with 2G ram, so it is plenty powerful. 2. What do we do about this failure during the reinstall? Any suggestions as to where to look ...

convert from xlr to xls or xlt
can I convert an existing excel spreadsheet from xlr to xls or xlt fromat. I'm using me. ...

Converting a 2003 Access Database to a 2007 Version
At my work, we have an Access database that was created in 2003 version. And now we have a new employee with Microsoft 2007 on her computer and she is unable to use the Access Program. I am guessing because it is an old version. Is there an easy way to either convert the database or do i need to do something else? Any advise is appreciated!! thanks She should be able to use the 2003 Access program. What happens when she tries? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Bonnie" wrote: >...

can't view exchange information store or directory in arcserve 2000
I hope someone can help with this. I am running Arcserve 2000 and have the exchange (2000) agents loaded on the same W2K servers. In Arcserve when I click on the Microsoft Exchange Server node under the source tab on the left, in the top right window it tells me 'There are no items to display in this view'. I have 2 exchange servers in the one organisation and the same happens with both. I would contact CA support. On 26 Apr 2005 05:37:17 -0700, john.robinson@inyx-pharma.co.uk (john r) wrote: >I hope someone can help with this. > >I am running Arcserve 2000 and have the...

Can I install 2 versions
I would like to install Money 2005 Small Buisness but I don't want it to affect my Money 2004 Deluxe I use for my home accounts. Yes. You need to install in a different folder and tell the new install not to deinstall the old version. There should be something in the readme. The last version installed will set the file associations. You can get around this with shortcuts to the version you want to run that specify the associated file. Downloaded files could get interesting. I don't mess with downloaded data, so I can't say how that works out. "Adam" <Adam@discu...

POP3 clients can't connect to Exch2003/SP1
telnet open e3k 110 user doe pass *** -ERR The specified module could not be found. 2 servers E2000/SP3 first in domain & E2003/SP1 as proposed by MSKB - 821896- swing upgrade... POP3 connect to mailboxes works untill - May be IMF (Intelligent Message Filtering) install? Connect ability broken aproximately near the time of install. Any advises are welcome! P.S. good old E2K accepts POP3 nice, (even now) but we dreaming to upgrade him to 2003... and allready moved users & pub stuff there... ...

Converting from 2002 standard
Hi, I've problem when i try to convert my money file from the 2002 standard version, it keep on saying cannot open it due difference version. Any help is greatly appreciated. TIA In microsoft.public.money, Sebastian wrote: > > >I've problem when i try to convert my money file from the >2002 standard version, it keep on saying cannot open it >due difference version. Money cannot open a version localized for another country. http://support.microsoft.com/default.aspx?scid=kb;EN-US;197668 http://support.microsoft.com/default.aspx?scid=kb;EN-US;178830 Get a later ve...