Just reference the cell address the text is in. In the example below the
function gets the value in cell A1 (either text or numeric):

=A1

--
Kevin Backmann


"Evan" wrote:

If I want to copy text from one text cell to another blank text cell, what is
the formula?