Need to add text to all cells in excel or merge the text in two ce

J

Juan Maldonado

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.
 
J

Jacob Skaria

--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
 

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

Top