"jiml" thank you for your response. Please see my reply to FSt1. I couldn't
reply to both of you at once. Or at least I didn't know how to. Thanks.
--
JAKA


"jiml" wrote:

Before doing anything else, save a backup copy under a different name. Then
save the copy under the original name. So if you mess up, you can go to the
backup copy.

Use the CONCATENATE function and fill down.

If you don't want the original cells to show up (say that your data's in
column A and you put the formula in column B), highlight column B, right
click, copy, then right click again, paste special, select values. Then you
can delete column A without column B getting a lot of #VALUE errors.


"KAD" wrote:

I would like to add a hypen and a number to each entry in cells within a
column. Each cell contains different info. Is there an easy manner to make
this happen?
--
JAKA