Thread: Pasting the same text over and over

Hi,
I need to add specific text to every cell in front of what's currently in the cell. So for example: I want to add "mmsub_" to the something like following:
1-2
1-3
2-5
3-6 etc.

so the final would look like:
mmsub_1-2
mmsub_1-3
mmsub_2-5
mmsub_3-6 etc.

is the a way just to this add text in front of all cells?

The best way I think would be to use a temporary formulae to generate the strings for you... assume your values are in A1 onwards then say

B1: =IF($A1="","","mmsub_"&$A1)
copy down for all your values

Now copy B1:Bx (where x is last row) and Copy -> Paste Special -> Values over A1:Ax ... then delete the temp formulae from B.