Not the most elegant solution but if I understand correctly [it's the same
text that needs to be inserted into each of the other 145 cells & those
cells are consecutive cells in the same column] it should work;
Using the example that the existing 145 entries begin in cell A1 & that
column B is available, enter the new text into any cell as long as it won't
be in the way of column B. (I'm using D1 in the example.)
In cell B1 enter the formula: =CONCATENATE($D$1,A1)
Note: The $ is necessary for an Absolute reference to D1, do not include it
in the reference to A1 because that needs to change as you...
Copy the formula down column B as far as necessary.
Note: If you need any characters ‹ such as a space ‹ included between the
new content & the old, just add another argument to the formula, such as:
=CONCATENATE($D$1," ",A1)
HTH |:>)
Bob Jones
[MVP] Office:Mac