how can i insert a word into many cells in a list
 

I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.

how can i insert a word into many cells in a list
 

If your words are in A1:A40, say, and you want to add "new_word" to
them, you can put this formula in B1:

="new_word "&A1

or this if you want to add it to the end:

=A1&" new_word"

and copy the formula down. You can fix the values in column B by
highlighting the cells with the formula in, click <copy, then Edit |
Paste Special | Values (check) | OK then <Esc. You can now <copy
column B data and <paste it over column A, and then delete column B.

Hope this helps.

Pete

On Jul 2, 12:42*pm, Cheekyscampster
wrote:
I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.

how can i insert a word into many cells in a list
 

Thats great Pete_Uk, and helps in some way, but being a total numpty I can't
work out how to make the words seperate so its 'red car' not 'redcar'

there are also other probs, i need the beginning and end of the word to have
inverted commas (" ")! also I was hoping that I could reference a seperate
cell for my word, as in a1 has the first word, b1 has the 2nd word, c1 has
the combined word with inverted commas.

sorry to be a pest but this would make my life much easier!

"Pete_UK" wrote:

If your words are in A1:A40, say, and you want to add "new_word" to
them, you can put this formula in B1:

="new_word "&A1

or this if you want to add it to the end:

=A1&" new_word"

and copy the formula down. You can fix the values in column B by
highlighting the cells with the formula in, click <copy, then Edit |
Paste Special | Values (check) | OK then <Esc. You can now <copy
column B data and <paste it over column A, and then delete column B.

Hope this helps.

Pete

On Jul 2, 12:42 pm, Cheekyscampster
wrote:
I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.

how can i insert a word into many cells in a list
 

In Pete's example, please observe there is a "space" inside the quotes
around "new_word" as in "spacenew_word" or "new_wordspace"

Cheekyscampster wrote:

Thats great Pete_Uk, and helps in some way, but being a total numpty I can't
work out how to make the words seperate so its 'red car' not 'redcar'

there are also other probs, i need the beginning and end of the word to have
inverted commas (" ")! also I was hoping that I could reference a seperate
cell for my word, as in a1 has the first word, b1 has the 2nd word, c1 has
the combined word with inverted commas.

sorry to be a pest but this would make my life much easier!

"Pete_UK" wrote:


If your words are in A1:A40, say, and you want to add "new_word" to
them, you can put this formula in B1:

="new_word "&A1

or this if you want to add it to the end:

=A1&" new_word"

and copy the formula down. You can fix the values in column B by
highlighting the cells with the formula in, click <copy, then Edit |
Paste Special | Values (check) | OK then <Esc. You can now <copy
column B data and <paste it over column A, and then delete column B.

Hope this helps.

Pete

On Jul 2, 12:42 pm, Cheekyscampster
wrote:

I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.

how can i insert a word into many cells in a list
 

Ah yes, I see how that works now. I was trying to get the formula to work
with cell references, which didn't leave spaces i.e. =e10 &f10

thats where i was struggling to get a space between, should proof read my
own replies in future!

Thanks anyway Bob I

"Bob I" wrote:

In Pete's example, please observe there is a "space" inside the quotes
around "new_word" as in "spacenew_word" or "new_wordspace"

Cheekyscampster wrote:

Thats great Pete_Uk, and helps in some way, but being a total numpty I can't
work out how to make the words seperate so its 'red car' not 'redcar'

there are also other probs, i need the beginning and end of the word to have
inverted commas (" ")! also I was hoping that I could reference a seperate
cell for my word, as in a1 has the first word, b1 has the 2nd word, c1 has
the combined word with inverted commas.

sorry to be a pest but this would make my life much easier!

"Pete_UK" wrote:


If your words are in A1:A40, say, and you want to add "new_word" to
them, you can put this formula in B1:

="new_word "&A1

or this if you want to add it to the end:

=A1&" new_word"

and copy the formula down. You can fix the values in column B by
highlighting the cells with the formula in, click <copy, then Edit |
Paste Special | Values (check) | OK then <Esc. You can now <copy
column B data and <paste it over column A, and then delete column B.

Hope this helps.

Pete

On Jul 2, 12:42 pm, Cheekyscampster
wrote:

I have a list of words, say 40 or so, and I want to insert one word into each
cell, which is the same word, without typing that word into each cell. is
there some way of doing this? The word will go before or after the word in
the list, not in the middle of it.

I searched for a prefix formula but seem to have come to a dead end.