Concatenate Will Only Work for the Cell

  • Thread starter Thread starter M_FLEMING
  • Start date Start date
M

M_FLEMING

I am trying to concatenate a column with the string "M0101" and the value of
the previous column. I have try several methods such as manually entering the
formula (="M0101"&A3) and also using the concatenate function. However it
will only work for the first cell. When I copy the formula to the remaining
cells in the row. I get the result of the first cell. Please help.


Thanks,
Myron Fleming
 
The fact that the formula does something, but seems to be stuck, is an
indaction that perhaps Calculation is not Automatic. Make sure:

Tools > Options > Calculation > automatic is checked.
 
Make sure that you have calculation set to automatic.

In xl2003 menus:
tools|options|calculation tab|check automatic
 

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

Concatenate not working 2
Excel Concatenate with line breaks but ignore blank cells 3
undo concatenated cells 2
undo concatenated cells 1
How to concatenate text into a formula? 5
summarizing data from various workbooks 3
Concatenating & Formatting 5
How to simplify CONCATENATE 3

Back
Top