Results 1 to 4 of 4

Thread: Simple problem

  1. #1
    Join Date
    Sep 2005
    Posts
    313

    Unanswered: Simple problem

    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.

  2. #2
    Join Date
    Oct 2003
    Posts
    311
    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

  3. #3
    Join Date
    Jan 2006
    Location
    Texas
    Posts
    4
    Try hiding Rows 2&3 so it doesn't show up on the screen.


    Quote Originally Posted by mikezcg
    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

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Try this:

    =CONCATENATE(INDIRECT("$A$2"),INDIRECT("$A$3"))
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •