MS Excel column changes
 

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

MS Excel column changes
 

hi
an example of your data would have been nice but try this in a helper
column...
=A2 &"-1"

regards
FSt1

"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

MS Excel column changes
 

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

MS Excel column changes
 

If you mean every cell would look like --
A-#### (A-12234; A-4785; A-2957,etc.)
Then go to Format Cells, Number tab, Custom, and enter A-####
.... unless I am interpreting your question on a "too basic" level.

"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

MS Excel column changes
 

Thank you for your help. Sorry, should have included an example. However, I
want to keep the information already in each cell and just add a hyphen and a
number to the information. Each cell contains information such as, CS. I want
to make it CS-1.

The next cell contains, INST...want to make it INST-1 and so on down the
list. Thanks.
--
JAKA


"FSt1" wrote:

hi
an example of your data would have been nice but try this in a helper
column...
=A2 &"-1"

regards
FSt1

"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

MS Excel column changes
 

"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

MS Excel column changes
 

hi
you can keep the original information. the helper column(Added) would house
the new data. after you are happy with the results, copy the helper column
and on the menu bar....editpaste specialvalues. this would turn the fomula
into hard data. you can then delete the orginal column or archive it just in
case.
the helper column was not ment to add an extra column but to help in adding
the additional data to the data already there. after that one of the columns
in no longer needed.

Regards
FSt1


"KAD" wrote:

Thank you for your help. Sorry, should have included an example. However, I
want to keep the information already in each cell and just add a hyphen and a
number to the information. Each cell contains information such as, CS. I want
to make it CS-1.

The next cell contains, INST...want to make it INST-1 and so on down the
list. Thanks.
--
JAKA


"FSt1" wrote:

hi
an example of your data would have been nice but try this in a helper
column...
=A2 &"-1"

regards
FSt1

"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

MS Excel column changes
 

So what result did you get when you tried FSt1's suggestion?
It appears to do exactly what you asked for.
--
David Biddulph

"KAD" wrote in message
...
Thank you for your help. Sorry, should have included an example. However,
I
want to keep the information already in each cell and just add a hyphen
and a
number to the information. Each cell contains information such as, CS. I
want
to make it CS-1.

The next cell contains, INST...want to make it INST-1 and so on down the
list. Thanks.
--
JAKA


"FSt1" wrote:

hi
an example of your data would have been nice but try this in a helper
column...
=A2 &"-1"

regards
FSt1

"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