Combine a range with a constant number
I have looked for something on this and have yet to find the answer...
I have a range in Workbook1 sheet1 column A that I need to copy to...
1 2 3 4 etc..
Workbook2 sheet1 column A, But I need to add the number 908 before the
copied data...so when it is pasted into Workbook 2 its value is;
9081 9082 9083 9084 etc...
How do I go about doing this??
Thanks,
Hans
|