Seperate text for numbers

[jeffreybrown]

What formula can I use in column B to extract the results in the attached table? All values in column A are text, but the criteria is to extact only text which does not contain a number.

Excel Workbook
	A	B
1	IL
2	AAAAA	AAAAA
3	F52C
4	A113C
5	T001A
6	T006A
7	T038C
8	BBB	BBB
9	TG010B
10	TG010C
11	TG015A
12	CCCC	CCCC
13	RQ004B
14	T038A
15	TU002S
Sheet1

Excel 2007

 

[Haseeb Avarakkan]

Hello,, Try

=IF(COUNT(FIND({0,1,2,3,4,5,6,7,8,9},A2)),"",A2)

 

[jeffreybrown]

Perfect...many thanks