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