View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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