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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula result (text) only - without copying formula
Hi Mulberry,
Have you tried copying your (A-John) cell, then right click on your destination cell and paste special then tick the "values" box? -- Regards Warren "Mulberry" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formula result (text) only - without copying formula
Warren Easton
So simple, so right - thank you. Mulberry "Warren Easton" wrote: Hi Mulberry, Have you tried copying your (A-John) cell, then right click on your destination cell and paste special then tick the "values" box? -- Regards Warren "Mulberry" wrote: 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 |
Reply |
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) |