Inserting Value of one cell into text of another.

[futureancient]

Apologies, I'm not sure I described in the title what I'm trying to do...

I have a value in cell A1 - determined by a variety of other unimportant calculations.

In cell B1 I have a line of text which I want to insert the number in A1 into the middle of.

eg A1 = "6" B1 = "I have inserted the number 6 (ie Cell A1) into this line of text.

This is probably extremely simple to do, but I am a complete novice. I have one other question which I will use a different thread for. Thanks for any help you can offer..

 

[Scott Huish]

="I have inserted the number " & A1 &" (ie Cell A1) into this line of text."

 

[c_m]

Try in B1:
="I have inserted the number "&A1&" (ie Cell "&ADDRESS(ROW(A1),COLUMN(A1),4)&") into this line of text"

 

[Scott Huish]

To include the cell address in the formula, here's another way:

="I have inserted the number " & A1 &" (ie Cell " & SUBSTITUTE(CELL("address",A1),"$","") &") into this line of text."

 

[futureancient]

Thanks guys, so quick.. I think I may have confused the issue in my post.. HOTPEPPERS first answer is I believe what I was looking for... just the number inserted into the text..

The problem is, it doesnt seem to have worked. I have typed it in just as suggested, but all I'm seeing is exactly that - "I have inserted the number " & A1 &" (ie Cell A1) into this line of text"

and not as I had hoped - "I have inserted the number 6 (ie Cell A1) into this line of text".. not sure why.

 

[Scott Huish]

Make sure the cell is not formatted as text and there does need to be an = sign in front.

 

[futureancient]

Thanks for your help !