Filtering values

[TheIceman1403]

I have a column with folder-names, lots of them. I need to filter the ones which start with 4 letters followed by 4 numbers.
For example, "BAEC4587" is the structure I need to filter out of my column. I've been playing with "Begins with" text-filter but ended somewhere with forest and trees.
I don't see any solution except of copying partial data to other columns and cutting and pasting stuff...

Any ideas?

 

[AlanY]

this solution works with a helper column

Book1
	A	B	C
1	ABCD1234		ABCD1234
2	ABCD1235		ABCD1235
3	ABCD1236		ABCD1236
4	ABCD12373
5	ABCD1238		ABCD1238
6	ABCD1239		ABCD1239
7	ABCD1240		ABCD1240
8	ABCD1241		ABCD1241
9	BBCD1242		BBCD1242
10	XABCD1243
Sheet1

Cell Formulas
Range	Formula
C1:C10	C1	=IF(AND(LEN(A1)=8,ISTEXT(LEFT(A1,4)),ISNUMBER(VALUE(RIGHT(A1,4)))),A1,"")

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$1:$A$12	C1

 

[AlanY]

with filter applied

Book1
	A	B	C
1	ABCD1234		Y
2	ABCD1235		Y
3	ABCD1236		Y
5	ABCD1238		Y
6	ABCD1239		Y
7	ABCD1240		Y
8	ABCD1241		Y
9	BBCD1242		Y
Sheet1

Cell Formulas
Range	Formula
C1:C3,C5:C9	C1	=IF(AND(LEN(A1)=8,ISTEXT(LEFT(A1,4)),ISNUMBER(VALUE(RIGHT(A1,4)))),"Y","")

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$1:$F$10	C1

 

[TheIceman1403]

this solution works with a helper column

Book1
	A	B	C
1	ABCD1234		ABCD1234
2	ABCD1235		ABCD1235
3	ABCD1236		ABCD1236
4	ABCD12373
5	ABCD1238		ABCD1238
6	ABCD1239		ABCD1239
7	ABCD1240		ABCD1240
8	ABCD1241		ABCD1241
9	BBCD1242		BBCD1242
10	XABCD1243
Sheet1

Cell Formulas
Range	Formula
C1:C10	C1	=IF(AND(LEN(A1)=8,ISTEXT(LEFT(A1,4)),ISNUMBER(VALUE(RIGHT(A1,4)))),A1,"")

Named Ranges
Name	Refers To	Cells
_FilterDatabase	=Sheet1!$A$1:$A$12	C1

Thanks, this worked. Thought there was a way of using the filter in multiple layers.