if "rakesh kumar" is in A1, this formula will return "kumar rakesh"
=LEFT(MID(A1,FIND(" ",A1&" ")+1,100)&" "&A1, LEN(A1))
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".
There are currently 1 users browsing this thread. (0 members and 1 guests)