EXCEL 2007
Assuming that your, "text formula in one worksheet" is in Book1 cell D4.
Go to Book2 cell D4 (or any cell of your choice) type in:-
=[Book1]Sheet1!$D$4
Book2 cell D4 will now be populated with, "the resulting text into another
worksheet".
If my comments have helped please hit Yes.
Thanks.