Results 1 to 4 of 4

Thread: Reverse name in excel with upper case,edit formula

  1. #1
    Junior Member
    Join Date
    Sep 2012
    Posts
    3
    Rep Power
    0

    Reverse name in excel with upper case,edit formula

    hi

    =UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(N3)," ",REPT(" ",99)),(1+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>2)+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>4))*99))&","&N3,LEN(N3)))

    the above formula is this way

    srinivas shinda singh will come Output- SINGH,SRINIVAS SHINDA upto 3 words will take last single word reverse

    srinivas shinda singh kumar Output -SINGH KUMAR,SRINIVAS SHINDA upto 4 to 6 words need to take 2 last words reverse

    srinivas shinda singh kumar sons Output-SINGH KUMAR SONS,SRINIVAS SHINDA SINGH above 6 words need to take last 3 words reverse .

    this all i am getting in above formula need to get if this single character comes with dot.

    Srinivas m.t. OUTPUT T,SRINIVAS M.

    Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

    srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.

    need to edit the above formula and add this changes to above formula i need all the out put in one formula

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    This question is cross-posted here...

    Reverse name in excel with upper case

    and here as well...

    http://www.mrexcel.com/forum/excel-q...ml#post3263931

  3. #3
    Junior Member
    Join Date
    Sep 2012
    Posts
    3
    Rep Power
    0
    this out put is not comming

    Srinivas m.t. OUTPUT T,SRINIVAS M.

    Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

    srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.

    need to edit the above formula and add this changes to above formula i need all the out put in one formula

  4. #4
    Junior Member
    Join Date
    Sep 2012
    Posts
    3
    Rep Power
    0
    hi need it very urgent ,i think you can only solve it

    this out put is not comming

    Srinivas m.t. OUTPUT T,SRINIVAS M.

    Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

    srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.

Similar Threads

  1. Reverse Vlookup Using Choose Function
    By Excel Fox in forum Excel Help
    Replies: 8
    Last Post: 07-04-2013, 01:50 AM
  2. VBA Macro To Convert Text To Proper Case
    By Howardc in forum Excel Help
    Replies: 4
    Last Post: 05-31-2013, 12:38 AM
  3. How To Protect Hide Formula In Excel
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 04-10-2013, 08:33 AM
  4. How To Make A Calendar In Excel Using Formula
    By rich_cirillo in forum Excel Help
    Replies: 6
    Last Post: 03-26-2013, 07:21 PM
  5. Change Case of Text in Excel
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 08-11-2011, 08:33 AM

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
  •