• Creator
  • #2270432

    Any Excel Gurus Out There?


    by hull_max ·

    hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciated

All Answers

  • Author
    • #2599133


      by hull_max ·

      In reply to Any Excel Gurus Out There?


    • #2599122

      re: merged cell reference

      by thumbsup2 ·

      In reply to Any Excel Gurus Out There?

      If you’re getting #value in the single cell, you must have something wrong with your formula. Referencing values in a merged cell is easy.

      Try this on a new speadsheet:

      merge cells A1 and B1, then type a value in the cell.

      in C1, type the equal sign then click the merged cell, then type +3 and press enter.

      This operation takes the value of the merged cell (now A1) and adds the number 3 to it.

      So, if you’re getting #value in the single cell, look at what you’re trying to do. If you’re trying to add/subtract a number from text, you should be using the concatenate function and not the add/subtract function.

      Maybe, if you provided details of what you’re trying to accomplish in the single cell, we could help more.

    • #2662274

      I may have a solution

      by phoenixclarity ·

      In reply to Any Excel Gurus Out There?

      There is also the possibility of how you selected the merged cell range. This does work I have done it many times.

      If you have selected the merged cell range in the formula in the single cell, check to make sure that you only reference the first cell in the merged range. For example, you have a merged range of cell A1 to A3 and want to display the contents in cell B2, then in the formula that you have in B2 should only reference A1.

      Sometime when selecting the merged cell you want to reference it will take the range (A1:A3) which is incorrect.

      If you still get the error, it probably is an error in the formula.

      Hope this helps.

    • #2795853

      I believe this is what you need.

      by fourplus4minus8 ·

      In reply to Any Excel Gurus Out There?

      Try Format in Numbers/Custom/General

Viewing 3 reply threads