Replace data with the result of a formula

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

[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

[Jim K]

Hello Bruce,

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



"swatsp0p" wrote:

>
> 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
>
>
> --
> swatsp0p
>
>
> ------------------------------------------------------------------------
> swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
> View this thread: http://www.excelforum.com/showthread...hreadid=491439
>
>

[swatsp0p]

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

Cheers!