Combining 2 formulas into 1 cell

[mibarron]

Hello,
Long time viewer of this site, first time poster. I'm not sure if this is possible, but is there a way to combine these two formulas into one?

=IFERROR(LEFT(D2,FIND(" ",D2)-1),D2)
=IF(LEN(D2)>9,LEFT(D2,LEN(D2)-20),D2)

Both work great individually, but I really need to combine them. I just can't seem to make it work. Thank you in advance for your help!!

 

[mibarron]

It looks like the macro work for the ones with 2 or more capitalized words, but not for the ones that are singles. It's pulling back #Value . Is there a way to tweak the formula to pull in the single words as well?

[TABLE="width: 414"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD] MS REG [/TD]
[TD]MS REG[/TD]
[/TR]
[TR]
[TD] GAMESC [/TD]
[TD="align: center"]#Value ![/TD]
[/TR]
</tbody>[/TABLE]

 

[MartyS]

=getupper(A1, " ", IFERROR(IF(LEN(getupper(A1, " ", 2, " ") )> 8, 1, 2), 1), " ")

 

[mibarron]

You are AMAZING, MartyS!!! Thanks so much for all your help! It works wonderfully!

 

[MartyS]

Glad we got there!

Enjoy!