software

In Col A I have number strings that indicate the year in either the
first 2 or the first 3 numbers
204359687456 - 2004 year
982356441445 - 1998 year
I can use MID and LEFT to get 04 and 98 in Col B, but I want to add the
'prefixquot; of 20 or 19 so that the list will sort in the Worksheet column
and Pivot Table row.
Any help is appreciated.--
Curalice
------------------------------------------------------------------------
Curalice's Profile: www.excelforum.com/member.php...oamp;userid=28600
View this thread: www.excelforum.com/showthread...hreadid=502725=IF(LEFT(A1)=quot;2quot;,20amp;MID(A1,2,2),LEFT(A1,2))*1

Vaya con Dios,
Chuck, CABGx3
quot;Curalicequot; gt; wrote in
message ...
gt;
gt; In Col A I have number strings that indicate the year in either the
gt; first 2 or the first 3 numbers
gt; 204359687456 - 2004 year
gt; 982356441445 - 1998 year
gt; I can use MID and LEFT to get 04 and 98 in Col B, but I want to add the
gt; 'prefixquot; of 20 or 19 so that the list will sort in the Worksheet column
gt; and Pivot Table row.
gt; Any help is appreciated.
gt;
gt;
gt; --
gt; Curalice
gt; ------------------------------------------------------------------------
gt; Curalice's Profile:
www.excelforum.com/member.php...oamp;userid=28600
gt; View this thread: www.excelforum.com/showthread...hreadid=502725
gt;

In Col A I have number strings that indicate the year in either the
first 2 or the first 3 numbers
204359687456 - 2004 year
982356441445 - 1998 year
I can use MID and LEFT to get 04 and 98 in Col B, but I want to add
the
'prefixquot; of 20 or 19 so that the list will sort in the Worksheet
column
and Pivot Table row.

the formula =IF(LEFT(A1)=quot;2quot;,20amp;MID(A1,2,2),LEFT(A1,2))*1
worked for the 2004 year, THANKS!, now I am puzzed as to how to use it
for the 1998 year.

Many thanks.--
Curalice
------------------------------------------------------------------------
Curalice's Profile: www.excelforum.com/member.php...oamp;userid=28600
View this thread: www.excelforum.com/showthread...hreadid=502725
Ha, I got it
=IF(LEFT(C23453)=quot;9quot;,19amp;LEFT(C23453,2))*1--
Curalice
------------------------------------------------------------------------
Curalice's Profile: www.excelforum.com/member.php...oamp;userid=28600
View this thread: www.excelforum.com/showthread...hreadid=502725Sorry, I went to bed early last night and missed your post asking about the
quot;1998quot;.....I had it but guess I posted the older version,.....but the best
thing is, you figured it out yourself!.......and that's really what it's all
about......congratulations!

Vaya con Dios,
Chuck, CABGx3quot;Curalicequot; gt; wrote in
message ...
gt;
gt; Ha, I got it
gt; =IF(LEFT(C23453)=quot;9quot;,19amp;LEFT(C23453,2))*1
gt;
gt;
gt; --
gt; Curalice
gt; ------------------------------------------------------------------------
gt; Curalice's Profile:
www.excelforum.com/member.php...oamp;userid=28600
gt; View this thread: www.excelforum.com/showthread...hreadid=502725
gt;