lost . . .

[Guest]

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.

any help appreciated.

 

[Vitalie Ciobanu]

If there always will be only one cell with data you can try to put this in
your last cell, your you want the data to apper
=IF(A1<>"",A1,IF(B1<>"",B1,IF(C1<>"",C1,IF(D1<>"",D1,E1))))
and suppose the 5 cells is from A1 to E1

If there will be more cell with data, the first cell taht contains data will
be copied.
It the simpliest one as you didn't tell more detail about what you have and
what you need.

--
Name: Vitalie Ciobanu
Nickname: AISBERG
Homepage: http://aisberg.rau.ro


"(e-mail address removed)"

 

[Dave Peterson]

If there's only one of the six cells that contain data, you could use:

=a1&b1&c1&d1&e1&f1

The empty cells won't affect the string.

If your data contains numbers, you could just use:
=sum(a1:f1)

 

[Vitalie Ciobanu]

I'm sorry, there are 6 cells so the formula changes a little bit
=IF(A1<>"",A1,IF(B1<>"",B1,IF(C1<>"",C1,IF(D1<>"",D1,IF(E1<>"",E1,F1)))))

--
Name: Vitalie Ciobanu
Nickname: AISBERG
Homepage: http://aisberg.rau.ro


"(e-mail address removed)"