once more - - -

[carl.m.kuklis]

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

 

[David Biddulph]

"[email protected]"

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

You could try =A1&B1&C1&D1&E1&F1

 

[Dave Peterson]

You have more replies at your other post.

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