Ask Your Question

Format merged cell content

asked 2018-04-15 13:13:56 +0200

Det gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-04-15 15:02:01 +0200

pierre-yves samyn gravatar image


Have you tried:



edit flag offensive delete link more


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


Det gravatar imageDet ( 2018-04-15 18:48:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-04-15 13:13:56 +0200

Seen: 11 times

Last updated: Apr 15