software

This seems very easy right? Well, the name list that I am currently
converting is a little querky. I would like to do this----gt; 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(quot;,quot;,A1))) amp; quot; quot; amp; TRIM(LEFT(A1,FIND(quot;,quot;,A1)-1))

quot;Leviquot; wrote:

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

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

Regards,

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

quot;Bob Phillipsquot; gt; 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)

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

You're right Rick , I missed that bit.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;RagDyeRquot; gt; wrote in message
...
gt; It sounds like quot;homeworkquot; Bob, since he stipulates only 'certain'
functions
gt; should be used.
gt; --
gt;
gt; Regards,
gt;
gt; RD
gt; --------------------------------------------------------------------------
--
gt; -------------------
gt; Please keep all correspondence within the Group, so all may benefit !
gt; --------------------------------------------------------------------------
--
gt; -------------------
gt;
gt; quot;Bob Phillipsquot; gt; wrote in message
gt; ...
gt; It's no harder than the previous two time that you asked it.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove xxx from email address if mailing direct)
gt;
gt; quot;Leviquot; gt; wrote in message
gt; ...
gt; gt; This seems very easy right? Well, the name list that I am currently
gt; gt; converting is a little querky. I would like to do this----gt; Cell.A1
gt; [Smith,
gt; gt; John] Cell.A2[John Smith]
gt; gt; Here is hwere it gets a little tricky....I need to nest the TRIM
function
gt; to
gt; gt; remedy extra spaces incurred by the data input girl. I would also prefer
gt; to
gt; gt; use the RIGHT, LEFT functions in place of the MID function. I would
really
gt; gt; appreciate any advice I could get out there. A friend told me it can be
gt; done
gt; gt; but cannot remember the formula..
gt; gt; THANK YOU
gt;
gt;
gt;