Change Smith, John to John Smith

[Guest]

This seems very easy right? Well, the name list that I am currently
converting is a little querky. I would like to do this----> Cell.A1 [Smith,
John] Cell.A2[John Smith]
Here is hwere it gets a little tricky....I need to nest the TRIM function to
remedy extra spaces incurred by the data input girl. I would also prefer to
use the RIGHT, LEFT functions in place of the MID function. I would really
appreciate any advice I could get out there. A friend told me it can be done
but cannot remember the formula..
THANK YOU

 

[Guest]

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

 

[Bob Phillips]

It's no harder than the previous two time that you asked it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[RagDyeR]

It sounds like "homework" Bob, since he stipulates only 'certain' functions
should be used.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

It's no harder than the previous two time that you asked it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Bob Phillips]

You're right Rick , I missed that bit.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

It sounds like "homework" Bob, since he stipulates only 'certain' functions
should be used.
--

Regards,

RD
-------------------------------------------------------------------------- --
-------------------
Please keep all correspondence within the Group, so all may benefit !
-------------------------------------------------------------------------- --
-------------------

It's no harder than the previous two time that you asked it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

This seems very easy right? Well, the name list that I am currently
converting is a little querky. I would like to do this----> Cell.A1 [Smith,
John] Cell.A2[John Smith]
Here is hwere it gets a little tricky....I need to nest the TRIM

function

to
remedy extra spaces incurred by the data input girl. I would also prefer to
use the RIGHT, LEFT functions in place of the MID function. I would really
appreciate any advice I could get out there. A friend told me it can be done
but cannot remember the formula..
THANK YOU