Not real sure what you want but =SomeValue & " " & AnotherValue & " " &
YetAnotherValue.

Or you could create a constant in the Insert|Name|Define menu selection. In
the "Names in workbook" text box put aSpace then in "Refers to: put " ".
Then your formulay would look like this =SomeValue & aSpace & AnotherValue &
aSpace & YetAnotherValue.

HTH
doco

"greenrocksandsodoesschoolandmylife"
crosoft.com wrote in
message ...
to use a name that is made up of two or more words in a formula, any space
should be replaced with a what?