Format merged cell content

How can I format merged cell content.
I have here:

B1 12576,019 and C1 someText

and I would like to have:
D1 someText12576

I tried:
I formatted cell B1 to 12576 (Format code 0) and =C1&B1, but result is someText12576,019

Can i do it somehow like this: =C1&FORMAT(B1, "0")

But than i get Error:508


Have you tried:



Hi pierre-yves samyn,
thank you very much for your time and your answer.
Its working perfectly like you wrote!