How to transform formulas to the text?

[Yaroslaw Bondarenko]

I have working book Excel 2002. The primary data imported
from usual text files, are transformed by set of formulas
and summary tables and substituted in final cells which
then are printed. Big book... For me all is clear. For
those who will want made editions in the book, all looks
as death...
For simplification I want to transform the book to other
book that formatting was kept and cells contained only
values! No formulas, no macroses, no references and
summary tables - just pure text.
How to make it?

 

[Bernie Deitrick]

Yaroslaw,

Select all your cells, then copy and pastespecial values.

HTH,
Bernie
MS Excel MVP

 

[Yaroslaw Bondarenko]

It's OK now! I know how to make it!.. It is vvvvery simple.
If You want to know it too, ask me by e-mail.

 

[David McRitchie]

Hi Yaroslaw,
The purpose of the newsgroups is to share information.
Asking a question and then saying "nevermind, I found the answer"
is good to tell others that you found your answer, but it is not sharing.

Is your solution simpler than Bernie's.

I expect yours is a macro solution and probably lengthy. So if you
posted your solution, you would help others if it is a better solution,
and if it is not you might be shown something better and learn
more and again help others.

HTH,
Davidd McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm