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.