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

  • Thread starter Cheekyscampster
  • Start date
C

Cheekyscampster

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

Pete_UK

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
 
C

Cheekyscampster

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!
 
B

Bob I

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

Cheekyscampster

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
 
Top