" 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

One guess ..

Assume source cells in A1:F1

Put in G1's formula bar, then array-enter the formula by
pressing CTRL+SHIFT+ENTER
(instead of just pressing ENTER)
=INDEX(A1:F1,MATCH(TRUE,A1:F1<"",0))

G1 will return the contents of the 1st cell from the left
that's not "empty", i.e. <""

Copy G1 down if desired to return correspondingly
for other rows A2:F2, A3:F3, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---