Copy result of formula as value to another cell

[rogster001]

Hi all,

Could anybody please advise on this one? I am writing a little helper worksheet for converting upper case to lower case and visa-versa, this is no problem of itself but i would however like the end user to be able to edit the converted text, directly within the worksheet rather than copy cell contents and switch back to the application that provided the text content to start with.

In essence this scenario:

customer query form (seperate application) contains message all in upper case.

Custer services person copies the message content and pastes into my excel sheet cell containing the formula UPPER(), lower case is output to target cell.

Lower case output is also written to another cell but as free text only, so the customer services person can then edit this cell's contents changing a few letters back to caps as required, names etc.
Customer services can then copy this cell content and paste into whatever document they require.

I realise this could easily be accomplished with VBA but i dont really want a macro in the worksheet, can this be donw with a formula bar expression only?

I tried:
(formula in cell B1) =LOWER(A1)
(formula in cell A2) =IF(T(B1), (B2 = A1),"")

But the second line is not evaluated correctly, my usage i know, how can i get an expression like
IF cell_X = text Then cell Z = value of cell X

Or is this a code job only?

 

[rogster001]

I dont think this is do-able without resorting to a macro, i used a paste special but stupidly as i realised it is only a one time shot!

 

[grizle]

Correct but the paste special macro could be attached to a command button to simplify the operators job.

 

[moonfish]

This is impossible without VBA. You can't directly edit the result of a formula.

If you think you can educate the customer service a bit, try to teach them to use F2/F9.

 

[grizle]

Yes its a macro but I think thats the only way. As far as I know the result of a formula can only appear in the cell where the formula is located. Try and capitalise the result and you would be editing the formula, not the text output. Try this simple spreadsheet as a starting point:

http://www.4shared.com/document/Pt9pg5nh/Lower_case.html