Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    21

    Unanswered: Proper text in excel

    How can you convert text string to captialize the first letter of a sentence after a period also?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I wrote this uickl - it works but it feels a bit to convoluted.
    It capitalises the first letter of the cell A1
    Code:
    =CONCATENATE(UPPER(LEFT(A1,1)),LOWER(RIGHT(A1,LEN(A1)-1)))
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2006
    Posts
    163
    Why not use the PROPER worksheet function?

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Because I didn't know it existed
    I told you it was pretty convoluted
    George
    Home | Blog

  5. #5
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    I though the PROPER function capitalises ALL words, doesn't it?

    MTB

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You are indeed correct Mike!
    I think what the user wants is to capitalise the first word in every sentence (hence theextra bit about after a full stop!).
    I can only think of another convuleted way of doing this which is very inefective - so I don't want to post it.
    Hopefully someone will come up with a better idea
    George
    Home | Blog

  7. #7
    Join Date
    Mar 2006
    Posts
    163
    I think youll find that PROPER does that.

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I beg to differ;
    Code:
    a b c d e f		A B C D E F
    abcdef			Abcdef
    abc def			Abc Def
    ab. cde. F		Ab. Cde. F
    It capitalises the first letter of every word.
    George
    Home | Blog

Posting Permissions

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