View Single Post
  #4   Report Post  
JAG
 
Posts: n/a
Default how to import value from a cell into another cell behind a text st

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