copy formula result (text) only - without copying formula

M

Mulberry

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
 
W

Warren Easton

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?
 
M

Mulberry

Warren Easton
So simple, so right - thank you.
Mulberry

Warren Easton said:
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 said:
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
Click to expand...
Click to expand...
 
Top