B
berniean
I have a number of cells in a spreadsheet that contain the following:
PM: John Smith, Designer: Joe Blow, PM: 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
PM: John Smith, Designer: Joe Blow, PM: 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