It depends,

to find posdition of a space

=FIND(" ",A1)

To concatenate and add a space

=A1&" "&A2


Regards,

Peo Sjoblom


"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?