how to CHANGE THE name "rajeev Chhajer" to "Chhajer rajeev"

R

Rajeev Chhajer

I want to change the name and title placements in a cell/ worksheet/excel
file. For ex. the content of the cell is
"Rajeev Chhajer"
and i wanna change to
"Chhajer Rajeev"
Pl suggest for the same, if u know.
 
T

teylyn

with your name in A1, use

=MID(A1,FIND(" ",A1)+1,99)&" "&LEFT(A1,FIND(" ",A1)-1)

cheers

teylyn
'The Code Cage - Microsoft Office Help - Microsoft Office Discussion
(http://www.thecodecage.com)


I want to change the name and title placements in a cell
worksheet/excel
 
Top