Announcement

Collapse
No announcement yet.

Swap/Switch First & Last Names In Cell

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Swap/Switch First & Last Names In Cell



    hello, i need help in interchanging the position of words in a cell with VBA for excel.

    For example, iam having a name " rakesh kumar" in a cell i want to interchange the words about the space and make it to " kumar rakesh".

  • #2
    Re: Interchange

    if "rakesh kumar" is in A1, this formula will return "kumar rakesh"
    =LEFT(MID(A1,FIND(" ",A1&" ")+1,100)&" "&A1, LEN(A1))

    Comment


    • #3


      Re: Swap/Switch First & Last Names In Cell

      thank you my friend

      Comment

      Working...
      X