--Once you merge text using & (CONCATENATE) copy the cells PasteSpecial
Values OK..will convert the formulas to text...which can be copied to
another workbook/sheet.

If this post helps click Yes
---------------
Jacob Skaria


"Juan Maldonado" wrote:

Here is the thing, I need to either add text at the begining of a cell to all
the cells where I can copy paste the result to another place without a
formula being what I copy paste, or merge the text of two cells. I know
about =A2&" "&B2 and =CONCATENATE(A2," ",B2) but these leave me with the
formula to copy paste, I want to be able to copy the new merged text to
another file that I have where I need it. There are thousands of cells I
need to do this for and typing in the text at the begining of each cell isn't
viable.