Lookup last filled cell in row

I would like a formula in Col A that will give me the data in the last Col
of each row, i.e Trounce, Ian, Runnalls, Amanda will appear in Col A1:A4

A B C D E F
1 Alison Robert Barrett Trounce
2 Allison Harry Ian
3 Alma William Alwyn Robert Runnalls
4 Amanda

Thanks in advance

"Graham Savell" wrote...
I would like a formula in Col A that will give me the data in the last Col
of each row, i.e Trounce, Ian, Runnalls, Amanda will appear in Col A1:A4

A B C D E F
1 Alison Robert Barrett Trounce
2 Allison Harry Ian
3 Alma William Alwyn Robert Runnalls
4 Amanda

Adapting Aladin Akyurek's numeric searching approach to text, try this in
cell A1.

=HLOOKUP(CHAR(255),B1:IV1,1)

Then select A1 and fill it down as far as needed in column A.

Only anticipates minimum of 25 names in a row between B and Z,
but enter in A1:
=OFFSET(B1,0,COUNTA(B1:Z1)-1)
and Copy Down..
HTH

"Graham Savell" wrote in message
...
I would like a formula in Col A that will give me the data in the last Col
of each row, i.e Trounce, Ian, Runnalls, Amanda will appear in Col A1:A4

A B C D E
F
1 Alison Robert Barrett Trounce
2 Allison Harry Ian
3 Alma William Alwyn Robert Runnalls
4 Amanda

Thanks in advance