View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hansjhamm@yahoo.com is offline
external usenet poster
 
Posts: 47
Default 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