"Alec H" wrote in
message ...

Hi,

I have a column of data that consists of 2 and 3 digit numbers (eg 215
or 56), I need to add a prefix of EEL to all of them. As there are over
400 of them, they are all different and they are not concurrent (some
numbers are missing) I cant just drag and fill.....

Any ideas?

Let's say you put this formula in cell B1:

=CONCATENATE("EEL-",A1)

If cell A1 contained 215, then cell B1 (containing the formula) would now
contain:
EEL-215

Now, you need to copy the value from B1 to A1. Edit, Paste Special, Values,
and click OK. This pastes just the value, but not the formula, from B1 to
A1.

At this point, you're probably thinking what a pain it'll be to type that
formula all the way down column B, but you don't have to. With the cursor in
B1, Edit, Copy (or CTRL-C). Now, select all the cells you want to contain
the formula, and then Edit, Paste. Excel will automatically change the A1
reference in the formula to A2, A3, etc, depending on line number.

By the way, the formula does NOT have to be in an adjacent column. It could
be way off to the right where it's not even on the screen.