Replace data with the result of a formula

J

Jim K

Hello,

I have a long list of names in <first> <last> format and want to change them
to <last>, <first> format. I know how to do this with a fomula, but want the
column with the result to have the actual text, not the formula that produces
the text.

The only way I've figured out is to export the result of the formula to a
text file and then read it in again to replace the original column of text.
Is there a better way?
 
S

swatsp0p

Place your formula in a blank column B (insert if needed). Copy Column
B and in Column A use Paste Special>Values. Then Delete Column B.

No formula remain.

Does this work for you?

Bruce
 
J

Jim K

Hello Bruce,

Absolutely perfectly! Did not know about the "paste special" function. Many
thanks!
 
S

swatsp0p

I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers
 
Top