Arrangement of text in a cell

[brettg]

I have text in a cell of my spread sheet. It has last name then first
name. Is there a way to re-arrange this so the first name appears
first??

Brett

 

[Niek Otten]

If they are separated by a space:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1))

--
Kind regards,

Niek Otten

|
| I have text in a cell of my spread sheet. It has last name then first
| name. Is there a way to re-arrange this so the first name appears
| first??
|
| Brett
|
|
| --
| brettg
| ------------------------------------------------------------------------
| brettg's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33879
| View this thread: http://www.excelforum.com/showthread.php?threadid=536583
|