Hi All,

I have a data in below format in a Row. I need Alphabets in a column with out any gap.
Kindly send me the excel 2010 or 2013 compatible formula.


Data in Row - 1 30 40 A 3 40 55 B 44 50 6 K 2 7 88 M

Data needed in Column as

A
B
K
M

Thanks in Advance

Regards
Subhash A.