Hi,

I have a Excel problem,

eg.

cell A2 = File
cell A3 = Number

Then, I want to make them in one cell: I made like this
cell A1 = A2 & " " & A3

It works fine, but when I delete the cell A2 and A3, then A1 's answer does not come out. So, does any command keep the A1 value? Thanks.

Cell A1 is a formula, any changes in the value of the referenced cells A2 & 3 will change the value in A1 , same as using sum on a range and then changing the numers, the sum changes.

Range Value cell a1

Try hiding Rows 2&3 so it doesn't show up on the screen.

Try this:

=CONCATENATE(INDIRECT("$A$2"),INDIRECT("$A$3"))