Formula needed to copy only Alpha cells to another set of cells

[leigh3980]

Hi all,
I am in need of an all encompassing formula to copy only cells with alpha contents.
I have attached a spreadsheet to display this. Column A is the copy source and column F is the desired result location.

thanks in advance

Leigh

[Phuocam]

Try this ...

=IFERROR(INDEX(A:A,SMALL(IF(ISNUMBER(SEARCH($A$1:$A$14,"ABCDEFGHIJKLMNOPQRSTUVWXYZ")),ROW($A$1:$A$14),""),ROWS($A$1:A1))),"")

Array formula, enter with Ctrl+Shift+Enter.

[leigh3980]

Hi Phoucam,
you absolutely nailed this!!
thank you so much
Leigh

[Phuocam]

You are welcome.