Right(text, number of characters) function returns number of character of text starting from right. Example: Right(“Blogs Fred”, 4) will return Blogs as a result
Left(Text, number of characters) function returns number of characters of text starting from left. Example: Left(“Blogs Fred”, 5) will return Fred as a result
Length on any text can be determine using LEN(text) function.Example : Len(“Blogs Fred”) will return 10 as a result.
To find position of space in the text which can be done using Find(what to find, from where) function. Example : Find(“ “, ““Blogs Fred””) will return 6.
Formula: =RIGHT(A3,LEN(A3)-FIND(" ",A3))&" "&LEFT(A3,FIND(" ",A3)-1) will reverse the two words in A3