You're welcome, and appreciate the feed-back.
--

Regards,

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

"berniean" wrote in message
...
This works. Thank you very much.

"RagDyer" wrote:

Does this work for you:

=IF(ISNUMBER(SEARCH("designer",A1)),MID(A1,SEARCH( "designer",A1),
SEARCH("PD",A1)-(SEARCH("designer",A1)+2)),"")

?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"berniean" wrote in message
...
One note: My first instinct was Text to Columns, but not all the cells
have a
Designer, so the PD would be in the wrong column half the time.

"berniean" wrote:

I have a number of cells in a spreadsheet that contain the following:
PM: John Smith, Designer: Joe Blow, PD: Jane Doe

I can get the PM using =LEFT(A1,FIND(",",A1,1)-1)
I can get the PD using RIGHT(A1,LEN(A1)-FIND("PD:",A1,1)+1)

My question is, how do I get the Designer? I've tried combinations of
MID/FIND but I keep getting the #VALUE# error.

I need to separate these into their own columns and the list is
extensive,
else I'd retype it. The 3 names change from row to row.

Thanks,
Bernie