Assuming that your numbers are lying in Column A
Do the following
1. Insert a column B
2. enter the following formula in B1
="3-" & A1
3. Copy the formula to other rows as needed.
4. Copy column B and click on A1 and then Edit/Paste Special/Values.
5. Delete the column B.

Alok Joshi


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