Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting Additional Text in Spreadsheet
How do I add the same word to the start of 900 different text descriptions
globally without individually editing all 900 line items? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting Additional Text in Spreadsheet
you can create a new field and add:
="STARTWORD"&<Click the cell to combine copy this to all 900 lines. This should do the trick. -NAZ- On Jun 27, 8:54 am, SEBA Branch Inventory <SEBA Branch wrote: How do I add the same word to the start of 900 different text descriptions globally without individually editing all 900 line items? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting Additional Text in Spreadsheet
One way ..
Assuming source text running in A1 down and you want to prefix* the text: XXX *with a space after XXX Put in B1: ="XXX "&A1 Copy down to B900 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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? |
#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? |
Reply |
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) |