cell's literal value

Giganews Newsgroups
Subject: cell's literal value
Posted by:  Andy (an…@newyorkapplesales.com)
Date: Mon, 6 Oct 2003

Using Excel97

I have a data set downloaded from another program.  It has
columns filled with text values.  I would like to combine
this text
strings into one column.

What is the best way to do this?

Is there a way I can refer to the cell's literal value
rather than as
a reference to the cell and save the literal value into a
new cell?

Thanks in advance.