• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inserting a value into a long text

K

Krinsom

New Member
Hallo,

I have a text (a normal text) in which I´d like to insert a value, insert a number in between this text, a number which is in another cell .

This number changes every month.

How do I do that?


Cheers


Krinsom
 
Krinsom

You can add formatting to the number by

="some text " & Text(A1,"##0.00") & " and some more."

will return "some text 17.00 and some more." asuming 17 was in A1


There are lots of Text formats you can use

Have a read of

http://chandoo.org/wp/2008/02/25/custom-cell-formatting-in-excel-few-tips-tricks/
 
You must log in or register to reply here.
Back
Top