+ Reply to Thread
Results 1 to 7 of 7

Excel formula switch first and Second word but keeps 3rd and remaining word in single cell

  1. 09-29-2015, 03:26 PM #1
    iwanttoexcelinexcel
    iwanttoexcelinexcel is offline
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Excel formula switch first and Second word but keeps 3rd and remaining word in single cell

    for example:
    You May choose an icon for your message from this list

    result
    May You choose an icon for your message from this list

    Thanks and appreciate all the answers.
    Reply With QuoteRegister To Reply
  2. 09-29-2015, 03:36 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    many ways to do this, here is 1 way...
    =MID(A1,FIND(" ",A1,1)+1,FIND(" ",MID(A1,FIND(" ",A1,1)+1,99),1))&LOWER(LEFT(A1,FIND(" ",A1,1)))&MID(A1,FIND("$",SUBSTITUTE(A1," ","$",2),1)+1,99)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 09-29-2015, 04:08 PM #3
    iwanttoexcelinexcel
    iwanttoexcelinexcel is offline
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    Hi FDibbins,

    This works but whenever the result came the 2nd word is not on CAPITAL anymore

    for example:
    You May choose an icon for your message from this list

    result
    May you choose an icon for your message from this list
    Reply With QuoteRegister To Reply
  4. 09-29-2015, 04:09 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    OK, I figured you would not want the 2nd word Capped. Change to this...
    =MID(A1,FIND(" ",A1,1)+1,FIND(" ",MID(A1,FIND(" ",A1,1)+1,99),1))&LEFT(A1,FIND(" ",A1,1))&MID(A1,FIND("$",SUBSTITUTE(A1," ","$",2),1)+1,99)
    Reply With QuoteRegister To Reply
  5. 09-29-2015, 04:16 PM #5
    iwanttoexcelinexcel
    iwanttoexcelinexcel is offline
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    Great Thanks! appreciate your help

    Reply With QuoteRegister To Reply
  6. 09-29-2015, 04:17 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    Happy to help, thanks for the feedback
    Reply With QuoteRegister To Reply
  7. 09-29-2015, 04:22 PM #7
    iwanttoexcelinexcel
    iwanttoexcelinexcel is offline
    Registered User
    Join Date
    12-28-2011
    Location
    Manila, Philippines
    MS-Off Ver
    MAC 2019
    Posts
    80

    Re: Excel formula switch first and Second word but keeps 3rd and remaining word in single

    by the way can you please highlight what should i change in the formula to get the 2nd and 3rd word switch the 1st word.

    for example:
    You May Choose an icon for your message from this list

    result
    May Choose You an icon for your message from this list

    Thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Batch Compile 100+ multiple word documents into a single word document
    By JamesFrames8 in forum Word Formatting & General
    Replies: 4
    Last Post: 04-03-2014, 08:49 PM
  2. [SOLVED] Minimize Excel and switch to open word document
    By Jietoh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2013, 11:16 AM
  3. Formula to parse first name & surname from cell containing single word
    By mc84excel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-18-2013, 10:49 PM
  4. Nested formula to find the next instances of the same word in a single cell string
    By Rapper2nite in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-06-2013, 07:45 PM
  5. Cannot switch to an active excel workbook from word
    By kalt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2011, 11:44 AM
  6. [SOLVED] How can I copy a list from word into a single cell in excel
    By Hermes in forum Excel General
    Replies: 3
    Last Post: 10-11-2005, 11:05 AM
  7. [SOLVED] Is there a way to insert a word document into a single excel cell
    By Marty in Austin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2005, 09:05 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1