Inserting Additional Text in Spreadsheet

  • Thread starter SEBA Branch Inventory
  • Start date
S

SEBA Branch Inventory

How do I add the same word to the start of 900 different text descriptions
globally without individually editing all 900 line items?
 
N

naz

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-
 
M

Max

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
 
R

ryguy7272

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.
 
Top