What takes the place of a space in a formula?

  • Thread starter greenrocksandsodoesschoolandmylife
  • Start date
G

greenrocksandsodoesschoolandmylife

to use a name that is made up of two or more words in a formula, any space
should be replaced with a what?
 
D

doco

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

Peo Sjoblom

It depends,

to find posdition of a space

=FIND(" ",A1)

To concatenate and add a space

=A1&" "&A2


Regards,

Peo Sjoblom


"greenrocksandsodoesschoolandmylife"
 
R

RagDyer

If it's a name *AND* it's text, you *must* enclose it in quotes, SO ...
spaces are *allowed* between the quotes.

"john doe"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


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