You could, of course, simplify
=CONCATENATE("The phrase I want to insert",":"," ",B1) to
=CONCATENATE("The phrase I want to insert: ",B1) or to
="The phrase I want to insert: "&B1
--
David Biddulph


"Quin" wrote in message
...
Assuming your existing words are in column "B" you could put a Concatenate
function in the "A" column and "fill down" to combine the two. The
function
in your case will look something like this:

=CONCATENATE("The phrase I want to insert",":"," ",B1)

A good way is to use a wizard. Just click on the fx symbol and in the
search box type "concantenate". Press "go" and "ok". Enter in the "Text
1"
box your phrase. Next box goes your colon, next box goes your space and
for
the last, click on the cell with the existing words that are in column "B".

Once you have the basic formula in cell A1 you can fill down or just copy
/
paste it into cell A2, A3 etc.

If you like the results, you can then convert your result from its current
status as a formula into a more useable form of text by copying column A
and
using Paste Special to paste as a value.

If you want to experiment with a different and simple way of adding two
columns with words together just pick a cell and type an equals sign, then
select a cell containing the first text, then type "&" and click on a cell
containing the second text. Press enter

Good luck, you may want to read other posts about the Concatenate
Function.
Quin