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