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

It's always better to specify the cells that you are going to use,
then the formula can be tailored to you. In the formulae I gave you
there was a space after "new_word" in the first one and before it in
the second one, but if you want to pick the word up from a cell you
have to do it a bit differently.

Quotes have the character code 34, and I find it is easier to
incorporate this into a formula which requires quotes to be shown
(there are other ways).

So, to start off then, if you have the word red in A1 and car in B1,
then this formula in C1:

=A1 & " " & B1

will give you:

red car

in C1. The & symbol, called the concatenation operator, is used to
join text together, so this basically takes whatever is in A1 and adds
a space to it followed by whatever is in B1. If you want the quotes
around the first word, then the formula will have to become:

=CHAR(34) & A1 & CHAR(34) & " " & B1

to give you:

"red" car

If you want the quotes around the second word, then change the formula
in C1 to this:

=A1 & " " & CHAR(34) & B1 & CHAR(34)

to give you:

red "car"

Hope this helps.

Pete


On Jul 2, 1:21*pm, 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.- Hide quoted text -

- Show quoted text -