Paul, thanks for your interest and quick response.
Please reference response in Red
The following is an example of the variability of characters. Note the
one parts in red are the parts I want to identify
188-512
76-544
84-737-JP
JP
AT-2-CH
CH
CAA-166
FPC-7
FW-34-CH
CH
HD-12B-TH
TH
LMT-495781
MA-101
MAU/EX-3173
MB-16B
MBU-10A
STB-2-CH
CH
WG-9A-JP
JP
WHG-104
WHG-57
WJ-115-TH
TH
WT-458
WTE-12-CH
CH
WYL-240B-TH
TH
WYLA-1-TH
TH
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner
Sent: Friday, February 18, 2011 11:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification
Is the length of the PREFIX consistent? No
that is: in your example, you're using wyl- and WMF-
is it always 3 characters. No
also, you said SOMETIMES the suffix is preceded by: "-"
what is it otherwise? If there is a suffix, it will be preceded by an
"-" Yes, that is correct
Is it always a 2 character suffix (if present)? Yes 2 is the current
limit
Are you wanting a Excel Function solution? or VBA solution? I'm not
sure which is easier, not being a programmer, I have found that if I can
write a formula, I can record It into a macro (not always effiecnt but
it works, but I have worked either way. What is the easiest?
Paul
________________________________
From: Diamond Dave <dpehr...@walbro.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Fri, February 18, 2011 12:44:09 PM
Subject: $$Excel-Macros$$ Special Suffix Identification
I have a series of numbers with the number of characters being
variable and either Alfa or numeric, and sometimes characters are
separated with a "-", and some ending with -CH, -JP, -MX, -TH, -CC, -
AF.
What I want to do is in the next column, enter a suffix matching the
list from above.
Example: original number: wyl-927-TH would read TH, wyl-987 would
be blank, WMF-123-MX would show MX
Any help in sorting out this problem would be appreciated. if there
is a formual that could be incorporated into a macro or just a stand
alone macro either will work for me.
Thanks
Diamond Dave
--
------------------------------------------------------------------------
----------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
------------------------------------------------------------------------
----------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
