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