Creating an excel macro with a filter condition.Help

Hi members i am a bit in a mesh to filter certain data according to my condition to make my work simplier...i hope there must be a way out...

I have certain data in column A like in A1(12543 | sgh KJY-56 | 4142)
In column A2 (Pku | 551 | RJK-55 ,) AND SO ON...is long..

now what i want is that i want just The Values which are attached with a hyphen(eg Like "PTS-58" OR LIKE SST-213) Can i filter my column in such a way that just such values remain and others do not..please help

Note : Text delimate or Fixed width does not work as the values which iwant are not in same line or saperated by same character in every cell.


Can any one create an excel macro on this so that i can use it in every sheet..?? Also note it will be more good if suppose some values have a space like "AFT- 63" or "AFT -52" PLEASE NOTE THERE IS A GAP BETWEEN AFT- AND THE NUMBER...i also want to remove that space....if possible..
For information i want to tell you that the values i want is always of Three Alphabets...expert kingly help