Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to add text to all cells in excel or merge the text in two ce
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to add text to all cells in excel or merge the text in two ce
--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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text outside merge cells despite clicking wrap text | Excel Worksheet Functions | |||
I cannot see all of my text when I merge cells. | Excel Discussion (Misc queries) | |||
Can't Wrap text in the Merge Cells | Excel Discussion (Misc queries) | |||
VBA for Text/Cells merge | Excel Discussion (Misc queries) | |||
How do I merge new text into existing text cells. | Excel Discussion (Misc queries) |