How can you set a cells data using a formula?
 

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

=A1="Bob"

--
Regards,

Peo Sjoblom


"Moloth" wrote in message
...
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")

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


--
Regards,

Peo Sjoblom


"Peo Sjoblom" wrote in message
...
=A1="Bob"

--
Regards,

Peo Sjoblom


"Moloth" wrote in message
...
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")