You seem to have missed this - perhaps because we posted at the same
instant.

Pete

On Jul 2, 1:59*pm, Pete_UK wrote:
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