Is there a way to put the only the results of a formula in a different cell.

[Blue Baron]

I am looking for a way to put the results of a formula in a different cell without any formula appearing in the new cell, sort of like "Paste Special/Values" only doing it automatically with a formula or function, instead of manually. For example, if the results of a function are "George", I would like the text "George" to appear in an other cell, but one clicks on the cell, they will only see "George" and not some code in the formula bar. Is it possible to do this?

 

[Blue Baron]

I forgot to mention, I don't know VBA, so I want to do this without VBA.

 

[Peter_SSs]

Welcome to the MrExcel board!

A formula can only display its result in its own cell, it can not "push" that result to another cell. To put the result in another cell you would need vba - which you say you don't want.

A possible option is ..
- Select the cell with the formula
- Ctrl+1 to bring up the Format Cells dialog -> Protection tab -> Check the 'Hidden' box -> OK
- Review ribbon tab -> Protect sheet (apply password if you want but not compulsory) -> OK

Now when you select the cell with the formula, nothing will appear in the formula bar.

 

[Blue Baron]

Welcome to the MrExcel board!

A formula can only display its result in its own cell, it can not "push" that result to another cell. To put the result in another cell you would need vba - which you say you don't want.

A possible option is ..
- Select the cell with the formula
- Ctrl+1 to bring up the Format Cells dialog -> Protection tab -> Check the 'Hidden' box -> OK
- Review ribbon tab -> Protect sheet (apply password if you want but not compulsory) -> OK

Now when you select the cell with the formula, nothing will appear in the formula bar.

Thanks, but hiding it is not what I want to do. I wanted the cell to have plain text so someone else could cut and paste it somewhere else where we don't want formulas. That person is not at all experienced with excel and Past Special is beyond his skill level.

 

[Peter_SSs]

Thanks, but hiding it is not what I want to do. I wanted the cell to have plain text so someone else could cut and paste it somewhere else where we don't want formulas. That person is not at all experienced with excel and Past Special is beyond his skill level.

Then, without vba, I'm afraid that I don't have a solution for you.