| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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") |
|
#2
|
|||
|
|||
|
=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") |
|
#3
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a formula refer to given data even if I do a sort f. | Excel Discussion (Misc queries) | |||
| Formula presumes cells have data | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
| Formula to Extract Data from a Table | Excel Worksheet Functions | |||
Linear Mode
