How can you set a cells data using a formula?

[Guest]

I would like to set a cells data using a formula... is this possible?

For example is there a function to set cell A1 to have the value "Bob"

=set(a1,"bob")

 

[Peo Sjoblom]

=A1="Bob"

 

[Peo Sjoblom]

Note that a function can only return a value in the same cell that holds the
function.