[SOLVED] OK, That helps me change 1 cell to Proper case


"Excel VBA Help"

 


Play Friv Now - Play Friv Games
Go Back   The Code Cage Forums > Microsoft Topics > Microsoft Excel Forum
Our Info Pages:-
The Code Cage - Microsoft Office help

Notices

Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc.

 
 
Thread Tools Rate Thread Display Modes
  #1  
Old 2nd June 2010, 12:29
Gloria's Avatar
Gloria
Newsgroup Contributor
 
Posts: n/a
Posts Per Day: 0
My Top Tip Count:
Default OK, That helps me change 1 cell to Proper case
     Excel: General   


------ Register to get rid of these "In Post" ads! ------

Category: Excel: General   

1. Enter the formula in the first cell (b2, for example)
2. Select the cell that contains the formula. You will notice a small black square on the bottom right corner of the cell.
3. Click on the tiny square and drag down to the end. Each cell will automatically be filled with the formula with the cell number referenced by the formula incremented in each cell.

If step 3 doesn't work:
3. Right click on the tiny square and drag down to the end. When you release the mouse, a menu will appear. Select "series".

*******************************************************
When all your data is converted appropriately, select the entire column, copy, right click in an empty column, and select 'paste special'. In the window that appears, select 'values'.



CTMa wrote:

OK, That helps me change 1 cell to Proper case.
08-Jan-08

OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks.

CT Man

"Gord Dibben" wrote:

Previous Posts In This Thread:

On Monday, January 07, 2008 5:26 PM
CTMa wrote:

How do I change from upper case to proper case in excel 2002
Help is too confusing. I can tell from it that I have to do a formula for
proper case, but it is unclear how to do it

On Monday, January 07, 2008 5:32 PM
Tyro wrote:

If the upper case is in cell A1.
If the upper case is in cell A1. Put this in cell B1 =PROPER(A1)

Tyro

On Monday, January 07, 2008 5:44 PM
CTMa wrote:

I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this

"Per Erik Midtr??d" wrote:

On Monday, January 07, 2008 5:44 PM
CTMa wrote:

I still don't understand. I have never used a formula.
I still don't understand. I have never used a formula. I tried to click on
th fx tab and then help, but it itoo confusing. please give me the specific
steps I need to complete this

"Per Erik Midtr??d" wrote:

On Monday, January 07, 2008 6:10 PM
Gord Dibben wrote:

Don't click on the fx button, just type Per's formula into a cell.
Don't click on the fx button, just type Per's formula into a cell.

Also, open Help and type in "proper". When reading about that function there
will be a "how" button showing you how to copy the example formula to the
worksheet.

Also, since things like formulas are confusing, perhaps a basic tutorial in
Excel would assist.

Here are a few basic tutorials for Excel to get a beginner going.

http://www.usd.edu/trio/tut/excel/index.html

http://www.baycongroup.com/el0.htm

http://office.microsoft.com/en-us/tr...831141033.aspx


Gord Dibben MS Excel MVP

On Mon, 7 Jan 2008 14:44:01 -0800, CT Man <CTMan@discussions.microsoft.com>
wrote:

On Monday, January 07, 2008 6:19 PM
Tyro wrote:

If your name is "JOHN DOE" and is in cell A1, then select cell B1 and type the
If your name is "JOHN DOE" and is in cell A1, then select cell B1 and type
the following: =PROPER(A1) then press the enter key.

Tyro

On Tuesday, January 08, 2008 8:41 AM
CTMa wrote:

OK, That helps me change 1 cell to Proper case.
OK, That helps me change 1 cell to Proper case. I have to change a whole
spreadsheet. Basically, I imported some addresses into excel in order to do
a mailing and it capitalized all of the text. Thanks.

CT Man

"Gord Dibben" wrote:

On Tuesday, January 08, 2008 1:14 PM
Gord Dibben wrote:

To change the entire used range on a worksheet at once would require a Macro.
To change the entire used range on a worksheet at once would require a Macro.

Here is one to change all cells to Proper Case.

Sub Proper()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = Application.Proper(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub

If you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

or Ron de De Bruin's site on where to store macros.

http://www.rondebruin.nl/code.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and Insert>Module. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to Tool>Macro>Macros.

You can also assign this macro to a button or a shortcut key combo.


Gord

On Tue, 8 Jan 2008 05:41:01 -0800, CT Man <CTMan@discussions.microsoft.com>
wrote:

On Tuesday, January 08, 2008 11:06 PM
=?ISO-8859-1?Q?Per_Erik_Midtr=F8d?= wrote:

Re: How do I change from upper case to proper case in excel 2002
If you have your text i cell A1, but this formula in some other cell:
=Proper(a1)

Per Erik


Submitted via EggHeadCafe - Software Developer Portal of Choice
Producer/Consumer Queue and BlockingCollection in C# 4.0
http://www.eggheadcafe.com/tutorials...r-queue-a.aspx



The Code Cage Advertisment
Advertisement
 
The Code Cage at Facebookhe Code Cage at Twitter


Tags
case, cell, change, helps, proper

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

The Code Cage Affilliates



http://www.thecodecage.com/forumz tested by McAfee Security http://www.thecodecage.com/forumz tested by McAfee Security

All times are GMT +1. The time now is 04:40.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Template-Modifications by TMS
No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team.
Copyright ©2008 - , Simon lloyd.
We are not associated with nor employed by Microsoft in any way, we simply provide resources!
All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
UA-8135493-1
Cultural Forum | Study at Malaysian University
X vBulletin 3.8.7 Debug Information
  • Page Generation 0.17244 seconds
  • Memory Usage 6,256KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footerEnd
  • (1)ad_footerStart
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_headerEnd
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_leftcolumn_code
  • (1)ad_navbar_below
  • (1)ad_postbit_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)helpful_answers
  • (1)helpfulanswers_javascript
  • (1)navbar
  • (3)navbar_link
  • (3)navbar_noticebit
  • (52)option
  • (1)post_thanks_box
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_ctoptip
  • (1)postbit_wrapper
  • (1)showthread_changepostsowner_link
  • (1)showthread_extra_fields
  • (1)showthread_quickreply_mrgdp
  • (1)showthread_reason_popup
  • (1)spacer_close
  • (1)spacer_open
  • (1)su_form
  • (5)tagbit
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_datastore.php
  • ./includes/class_hook.php
  • ./awcoding/plugins/awc.php
  • ./awcoding/plugins/ds.php
  • ./awcoding/plugins/ss.php
  • ./includes/functions_notice.php
  • ./mobiquo/smartbanner.php
  • ./mobiquo/include/classTTConnection.php
  • ./mobiquo/smartbanner/head.inc.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/vbatags.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php
  • ./includes/functions_misc.php
  • ./includes/functions_prefix.php 

Hooks Called:
  • init_startup
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_check_criteria
  • notices_noticebit
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • helpfulanswers_showthreadorpost
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • helpfulanswers_show_normal
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • error_fetch
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete