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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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