text formula

[abanky]

anyone know if it is possible and if so how can i create a cell where the text has specific cell values in it some how.

example

a1-- If you go (g7) miles, turn right and then go (h4) miles.

where h4 is a number and g7 is a number. I understand that i could just shrink certain cells around it. but my main purpose is to create a big paragraph where every sentence has a value from another worksheet cell.

Thanks in advance
Andrew

 

[Andrew Poulsom]

Try this formula:

="If you go "&g7&" miles, turn right and then go "&h4&" miles."

 

[abanky]

Is there anyway to keep the format of the target cell? example say i wanted a sentence with a dollar value inserted in it

 

[Andrew Poulsom]

If your value is in A1, then

="That will be "&TEXT(A1,"$#")&" please."