if the numbers are in say column A, then insert a column B
in B1 enter the following formula

="3-" & A1

Copy the forumula down from B1 to the last row as necessary.
Then highlight column B and copy the column. Select A1 and Edit/Paste
Special/Values. Then delete 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!