troubleshoot concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the concatenate function. The columns are in text format.
When I try to copy the formula, it does not refresh in the cells, it copys
the text from the first cell. The formula is correct in the other cells, but
the text is the same text from the original cell. When I go to each cell and
hit "enter" after each formula, it then refreshes.
 
If you simply need to recalculate all cells, press the F9 function key. This
will recalculate the entire current workbook.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Concatenate with line breaks but ignore blank cells 3
Concatenate not working 2
Concantenate which keeps bold of some parts. 5
Last Modified By in a cell by user 3
Excel Typed text appears in wrong cell 0
Excel Concatenate cell data from column based on criteria in adjacent column 2
Concatenate multiple lines 2

Back
Top