On a copy of your file:

1) Temporarily insert a column adjacent to these cells
2) in the new column type (replace B2 with the address of the adjacent cell)
="3-"&B2
3) copy down through all 1000 cells
4) select all these new formulas
5) EditCopy
6) Select the original cells
7) EditPaste SpecialValues
8) Delete the temporary column


"amspalinger" wrote:

I'm trying to enter the same information into multiple cells that are already
filled - how can I do this in Excel??

Example -

12345
654321
78946
456798

I need to insert "3-" before each of the digits in these cells - There are
over 1000, that's why I don't want to do it manually. Any help would be
greatly appreciated!