Formula for when cell blank

[jb00976]

Hello,

I have I spreadsheet similar to this:

Account Manager Person Credited for Sale
Joe Smith Sally Jones
John Davis John Davis
Sarah Clark

Sometimes who the Account Manager is matches the Person Credited for Sale, sometimes it doesn't and sometimes the field for the Person Credited for Sale is blank. I want to pull from this sheet to another and have the formula yield the Person Credited for the Sale is and in the case of it being blank put the Account Manager name. I also need to use the trim function as some names have spaces after and some don't which is affecting my data thereafter. What would the formula look like using Trim and making sure there are no blanks?

Thanks

 

[FDibbins]

maybe this?

=if(formula="","",trim(formula)