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.
|