Results 1 to 2 of 2

Thread: Please suggest

  1. #1

    Question Please suggest



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,

    I have a requirement to convert the first word of the letter to upper case, and every first word after a '.' should be an upper case.

    See my requirement below.

    kapardhi.p.v.k should be changed to KapardhiPVK

    Please help.

  2. #2
    Use

    =SUBSTITUTE(PROPER(A2),".","")

Tags for this Thread

Posting Permissions

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