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.![]()
![]()
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.![]()
![]()
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
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
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)
Great Thanks! appreciate your help
![]()
Happy to help, thanks for the feedback![]()
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks