View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin McKellar Kevin McKellar is offline
external usenet poster
 
Posts: 1
Default Add Unique ID to end of every cell?

Hi, I have a spreadsheet with about 10 columns and 50
rows. I upload the spreadsheet to test an application
and need to modify the spreadsheet each time to make it
different.

What I would like is to be able to add a unique number or
a letter at the end of the data currently in Column C.
So if Column C now is (Adam, Steve, Roger) I would like
to make it AdamA, SteveB, RogerC.

Is there a way to macro this somehow? what is the
formula? I could not get auto fill to work.

thanks in advance if you can help.