Louise,

ISTEXT will do that

=IF(ISTEXT(A1),B1,"")
Drag down

Mike

"Louise" wrote:

Hi,

Can anyone tell me if there is a way to pick up (using an IF statement)
whether a cell has any letters in it, if a cell has letters in it I need to
pick up another cell.

Example of what I have:

Cost Centre Ref # IF Statement Answer

1234 0012 1234
2345 0014 2345
2346 9987 2346
TED 3865 3865 ** Show Ref # as Cost Centre has Letters in
it.
4678 3678 3678

Many Thanks in advance.