| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula result (text) only - without copying formula
I combined text from two cells using =(&""&). So [A-] from one cell and
[John] from another cell became [A-John] in a single cell. I copied this formula to a column of names with a view to assist in sorting further down the track. Can I 'de-formularise' the result..... transform [A-John] into text only so I can copy it without the formula and use it in other combinations and sorting? Many thanks for looking and, if you can, helping |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula but only getting the result | Excel Worksheet Functions | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
| How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
| copying a formula, the reference adjusts, but the result does not | Excel Discussion (Misc queries) | |||
Threaded Mode
