Remove spaces from 2 cells & join the alphabets

[hsandeep]

C5=MAngO123-99 Tomato D5=ITALIAN Forest Trees E5=26
In F5 I want first 26 (E5) digits after removing spaces from C5 & D5 & suffixing D5 with C5 & in UPPER CASE.
Answer:
MANGO123-99TOMATOITALIANFO.
How to accomplish?

 

[VoG]

Try

=LEFT(UPPER(SUBSTITUTE(C5," ","")&SUBSTITUTE(D5," ","")),E5)

 

[hsandeep]

It WORKS. Thank you.

 

[hsandeep]

Even "." (dot) needs to be removed from C5 & D5, if any.

 

[VoG]

Try

=LEFT(UPPER(SUBSTITUTE(SUBSTITUTE(C5," ",""),".","")&SUBSTITUTE(SUBSTITUTE(D5," ",""),".","")),E5)

 

[hsandeep]

It works.

 

[Peter_SSs]

I think you could also get away with just doing the substitutes once:

=LEFT(UPPER(SUBSTITUTE(SUBSTITUTE(C5&D5," ",""),".","")),E5)