one way

concatenate the six into the seventh cell

=a1&a2&a3&a4&a5&a6

should do it

--
Greetings from New Zealand
Bill K
"
om wrote in message
...
This may be simple but, I am stumped.

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