Hi,
Can anyone help me with this problem? i have a cell that has a formula. once
the formula has calculated, i want to press a button and "flatten" the
formula.
Example:
A5= Client1
B5= My Project Name
C5= £2500

formula = A5&" "&B5&" "&C5
( Client1 My Project Name £2500 )
want i want is once button ( macro is pressed, when i select the cell, it
shows the finished calculation. ( removing the formula but leaving
calculation showing )

Can this be acheived?

Regards,
Nigel