| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional rows added to spreadsheet when opening text files | Excel Discussion (Misc queries) | |||
| cell ref in function formula change when inserting additional colu | Excel Worksheet Functions | |||
| inserting an additional line of text within same cell | Excel Worksheet Functions | |||
| Inserting additional data into a cell | Excel Discussion (Misc queries) | |||
| Inserting additional data into an existing cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
