@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification
try this
On Sat, Feb 19, 2011 at 12:42 AM, Pehrson, Dave
wrote:
Thanks for your quick response, you're getting close, the following is
an example of what I'm trying to achieve. Column A is the original
data, and Column
gt; 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
>
>
>
> Thanks for your support
>
>
&g
ur support
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul
Sent: Friday, February 18, 2011 11:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Special Suffix Identification
See if it helps
On Fri, Feb 18, 2011 a
-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
See if it helps
On Fri, Feb 18, 2011 at 11:14 PM, Diamond Dave wrote:
> 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
Is the length of the PREFIX consistent?
that is: in your example, you're using wyl- and WMF-
is it always 3 characters.
also, you said SOMETIMES the suffix is preceded by: "-"
what is it otherwise?
Is it always a 2 character suffix (if present)?
Are you wanting a Excel Function solution? or VB
