G Guest Jun 27, 2007 #1 How do I add the same word to the start of 900 different text descriptions globally without individually editing all 900 line items?
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 Jun 27, 2007 #2 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-
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-
G Guest Jun 27, 2007 #3 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
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
G Guest Jun 27, 2007 #4 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.
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.
