Simple code to append numbers to the existing data in the cells
Hello
I have many colums of data (characters)
What I want to do is, highlight the required cells in the column and then
either press a button or whatever to trigger the code to run.
The code should append numbers to the existing data.
for e.g:
Column:
AA
BB
TH
XH
HB
SO
I want the code to do this:
30AA
31BB
32TH
33XH
34HB
35SO
Can the code ask me what is the starting number I want to append?
Can somebody show me a sample how to do this?
Thank you very much.
|