Results 1 to 10 of 10
  1. #1
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Excel question
    Is there an easy formula to capitalize all the words? I mean to make the first letter only a capital letter. Example change flowers to Flowers.

    I want to do this to every word on the spread sheet.

    There is no consistency in the way the merchants do it so I need to if my site is to look right.

    Thanks
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  2. #2
    Lite On The Do, Heavy On The Nuts Donuts's Avatar
    Join Date
    January 18th, 2005
    Location
    Winter Park, FL
    Posts
    6,930
    Function is called "Proper" [functions in parens - proper case (proper), lower case (lower) and upper case(upper)].

    =Proper(A1)

  3. #3
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Thank you but it wants me to insert the text in quotes. Is there any way I can make the whole sheet turn to Proper??

    Can you tell me what to do in a bit more detail?

    The instructions in Excel are about as clear as mud. They talk all around and about functions but don't tell you how to do it.
    Last edited by SSanf; February 6th, 2006 at 10:40 AM.
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  4. #4
    Affiliate Network Rep SarahJane's Avatar
    Join Date
    October 20th, 2005
    Location
    Montreal, Quebec, Canada
    Posts
    108
    The way I do it is to insert a new column to the left of the column I want to capitalize, insert the formula in the first cell and drag down to where the column to the right ends. Then, I copy the whole column I just created. Now I highlight the column I want to apply the formula to, and hit Paste - but I right click on Paste and hit "Paste Special", then I click the formulas button. Now I erase the column I used to get the formula's results.

    If the above made any sense to you at all, (as I am no Excel expert), you can apply that process to every column.

    Hope it works out.
    [LEFT][FONT=Verdana]Sarah-Jane
    Affiliate Manager
    Share Results Affiliate Network

    [URL=http://www.shareresults.com/ai_affiliatesignup1.php]Join the Share Results Affiliate Network today![/URL]

    e-mail: [EMAIL=sarah-jane @ shareresults.com]sarah-jane @ shareresults.com[/EMAIL]

    [URL=http://www.shareresults.com]www.shareresults.com[/URL]

    [I]"There is no psychiatrist in the world like a puppy licking your face"[/I]
    - Bern Williams

    [/FONT][/LEFT]

  5. #5
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    I copied the colum to the left and put "the formula"
    =Proper(A1) into A1 and all it did was give me an error.

    Is that what you meant for me to do?

    ~~~~~~~~~~~~~~~~~~~~

    Yea~!

    Got it!

    I had to copy the formula into B1!!!!!

    Thank you so much!!!!!
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  6. #6
    Affiliate Network Rep SarahJane's Avatar
    Join Date
    October 20th, 2005
    Location
    Montreal, Quebec, Canada
    Posts
    108
    Ok just saw the bottom part of your post, yeah! Glad it worked.
    [LEFT][FONT=Verdana]Sarah-Jane
    Affiliate Manager
    Share Results Affiliate Network

    [URL=http://www.shareresults.com/ai_affiliatesignup1.php]Join the Share Results Affiliate Network today![/URL]

    e-mail: [EMAIL=sarah-jane @ shareresults.com]sarah-jane @ shareresults.com[/EMAIL]

    [URL=http://www.shareresults.com]www.shareresults.com[/URL]

    [I]"There is no psychiatrist in the world like a puppy licking your face"[/I]
    - Bern Williams

    [/FONT][/LEFT]

  7. #7
    Lite On The Do, Heavy On The Nuts Donuts's Avatar
    Join Date
    January 18th, 2005
    Location
    Winter Park, FL
    Posts
    6,930
    I gave you the formula for translating the text in one cell (a1) into the proper case in another cell (your choice of cells).

    If you want to convert a range, you can use Visual Basic code to do it:
    http://www.ozgrid.com/VBA/force-case-text.htm

    If VB or Macros are foreign animals to you, you might find a free macro someone else has built and download it - here's one for your situation that I found (but did noit test in any way):
    http://www15.brinkster.com/corvette/...hangeCase1.asp

  8. #8
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    Tell you what. I am glad it worked, too!!!!

    You guys are the greatest!
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  9. #9
    Super Sh!t Stirrer SSanf's Avatar
    Join Date
    January 18th, 2005
    Posts
    9,944
    I found that you can do a whole sheet at once by copying all the columns and dragging diagonally across the second set of columns!!
    Comments are opinion unless otherwise noted. Remember, pillage first. Then burn. Half of all people in the world have IQs under 100. You best learn to trust ol' SSanf!

  10. #10
    ABW Ambassador buy_online's Avatar
    Join Date
    January 18th, 2005
    Location
    Richmond, VA
    Posts
    3,234
    I have a macro, which will allow you to select any text, and upper, proper, or lower-case it in excel.

    Let me know if you are interested, I'll post it. It's also at my site (free, of course).

    Fred

  11. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Question for MS Excel Guru's
    By jimh009 in forum Midnight Cafe'
    Replies: 5
    Last Post: March 12th, 2007, 03:45 AM
  2. Can you help with an Excel question?
    By zimmy in forum Midnight Cafe'
    Replies: 2
    Last Post: June 17th, 2006, 05:59 PM
  3. Excel/Datafeed Question
    By windowsguy in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: April 20th, 2004, 01:46 PM
  4. Excel question
    By netsu in forum Midnight Cafe'
    Replies: 2
    Last Post: January 31st, 2004, 07:31 PM
  5. Excel Question
    By ~Michelle in forum Midnight Cafe'
    Replies: 2
    Last Post: January 21st, 2004, 02:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •