add data without deleting information in cell
I have a column with information already in it and I want to add "_2007" to
the information already in the cells without deleting that information. Is there a fast way to do that? Each cell has different information in it so I don't think I can do a find and replace. |
add data without deleting information in cell
sub addatend() for each c in range("a2:a22") c.value=c.value & "_2007" next c end sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Hobher" wrote in message ... I have a column with information already in it and I want to add "_2007" to the information already in the cells without deleting that information. Is there a fast way to do that? Each cell has different information in it so I don't think I can do a find and replace. |
All times are GMT +1. The time now is 07:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com