Creating an excel macro with a filter condition.Help

[rishi.ssh]

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

[rishi.ssh]

Some one please help...need it badly..

[rishi.ssh]

Any expert on this..??

[rishi.ssh]

If that space between them isint possible than that will also do...as almost 80% of my data is without space..just attached with hyphen.

[icestationzbra]

could not figure out a formulaic way of doing this, hence explored the "regular expression" route. see if this helps you in your quest.

[rishi.ssh]

Heys whats dat in attachment....where is d solution...???

[jindon]

UDF

=Hyphen(A1)

Please Login or Register  to view this content.

[icestationzbra]

@rishissh:

the attachment that i have posted has a UDF in it called RishiSSH. you have to use it as a function call, like you would any other excel function. but first, you have to enable macros while opening that file.

if your record is in A1, then put =rishissh(A1) in B1 to have the string extracted into B1.

jindon's UDF is tighter and simpler; if you want to use that you would have to copy that into a VBA module and call it like a worksheet function.