| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula Calculation as Text ( no formula )
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use text in a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| TEXT SHOWS UP IN FORMULA BAR BUT NOT IN CELL? | Excel Discussion (Misc queries) | |||
| Formula appears as text | Excel Worksheet Functions | |||
| merging text without using a formula | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
