Replace data with the result of a formula
 

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?

Replace data with the result of a formula
 

Place your formula in a blank column B (insert if needed). Copy Column
B and in Column A use Paste SpecialValues. 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

Replace data with the result of a formula
 

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 SpecialValues. 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

Replace data with the result of a formula
 

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

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=491439