Ask Your Question
1

Format merged cell content

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

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
1

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

pierre-yves samyn gravatar image

Hi

Have you tried:

=C1&TEXT(B1;"0")

Regards

edit flag offensive delete link more

Comments

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

Regards

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

Question Tools

1 follower

Stats

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

Seen: 18 times

Last updated: Apr 15