View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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?