If you meant 3 before the values and not each digit you can use a help column
=3&A1
copy down as long as needed, copy and paste special as values
Regards,
Peo Sjoblom
"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!
|