software

I have a range of six cells in a row on my spread sheet. Five cells are empty
and one contains data. I would like to find the single cell that contains
text and copy that text into a cell at the end of the row

quot; gt; wrote in message
...
gt;I have a range of six cells in a row on my spread sheet. Five cells are
gt;empty
gt; and one contains data. I would like to find the single cell that contains
gt; text and copy that text into a cell at the end of the row

You could try =A1amp;B1amp;C1amp;D1amp;E1amp;F1
--
David Biddulph
You have more replies at your other post.
wrote:
gt;
gt; I have a range of six cells in a row on my spread sheet. Five cells are empty
gt; and one contains data. I would like to find the single cell that contains
gt; text and copy that text into a cell at the end of the row

--

Dave Peterson