Hi,

I try to put a value from one cell into another cell behind a text string,
i.e., getting the 20 in B1 in to A1 behind a word such as Result to get
Result (20) in A1. Is there a formaula to do this?

Thanks,
Xianbo

="Result " & B1

Thanks, Dave. Works great!

"Dave O" wrote:

="Result " & B1

If the text you are wanting to combine is in a list or another cell you can
use the concatenate formula to combine both into one cell.

"Xianbo" wrote:

Hi,

I try to put a value from one cell into another cell behind a text string,
i.e., getting the 20 in B1 in to A1 behind a word such as Result to get
Result (20) in A1. Is there a formaula to do this?

Thanks,
Xianbo