See one answer in response to your post in m.p.e.misc.

Please don't post the same question in multiple newsgroups. It tends to
fragment any answers you receive, and it potentially wastes the time of
those answering questions that have already been answered.

For tips on using these groups effectively, see

http://cpearson.com/excel/newposte.htm


In article ,
JonatanRaven
wrote:

A new problem has arisen.

I want to create a formula that will check if a certain cell has anytext and
if so show that text in another cell. If there is no text, Iwant excel to
show nothing. I think standard is 0.