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