Change Smith, John to John Smith

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

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

"Levi" wrote:

> 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

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Levi" <[email protected]> wrote in message
news:[email protected]...
> 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

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 !
----------------------------------------------------------------------------
-------------------

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
It's no harder than the previous two time that you asked it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Levi" <[email protected]> wrote in message
news:[email protected]...
> 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

You're right Rick , I missed that bit.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"RagDyeR" <[email protected]> wrote in message
news:[email protected]...
> 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 !
> --------------------------------------------------------------------------
--
> -------------------
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> It's no harder than the previous two time that you asked it.
>
> --
> HTH
>
> Bob Phillips
>
> (remove xxx from email address if mailing direct)
>
> "Levi" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>