copy partial cell content

[darkrealms]

With an unformated (general) cell, I'm not sure how to copy part of the content of a cell.
Example:
1382 Dow, John, WD
1685 Smith, George - FD

What I would like to get out of it is: Dow, John, WD and Smith, George - FD.
I have tried things like =LEFT((D3),-5) instead of =LEFT((D3),5) as an alternate, but haven't found a formating style with the subtraction anywhere in the code to get it to work. Not sure what else to try. I know how to take a piece out of say a date but not out of text.

If this has already been covered please link it for me, I tried searching but came up with nothing that I could use.

Thanks

 

[Andrew Poulsom]

Did you try?

=RIGHT(D3,LEN(D3)-5)

 

[ctrlaltdel]

Try this

How about
=MID(D3,FIND(" ",D3)+1,LEN(D3))?

This should give you what you want assuming the text you want is always right after the first space in the cell.

 

[ctrlaltdel]

Did you try?

=RIGHT(D3,LEN(D3)-5)

That's why you're the MVP! Much better solution than mine

 

[darkrealms]

Andrew Poulsom thank you! No I hadn't tried the LEN statement, I had tried something similar without it.

ctrlaltdel thanks for the responce, I agree Andrew's is a little easier : )