Inserting Additional Text in Spreadsheet
This macro will help you achieve your desired results:
Sub add_the_same_word()
For Each cell In Selection
cell.Value = "add the same word " & cell
Next
End Sub
FYI, change the stuff in quotes and make sure the cells are selected before
running the macro.
--
RyGuy
"SEBA Branch Inventory" wrote:
How do I add the same word to the start of 900 different text descriptions
globally without individually editing all 900 line items?
|