You can do that with a formul if you wish. In the cell where you would like
the value add the formula (assuming row 1)...

=A1 & B1 & C1 & D1 & E1 & F1

Which will concatenate all of the cell values together. Since 5 of the six
are blank it will be just the text from the one populated cell.
--
HTH...

Jim Thomlinson


" wrote:

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