View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Combine text and formula?

Sorry, I went to bed early last night and missed your post asking about the
"1998".....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, CABGx3


"Curalice" wrote in
message ...

Ha, I got it
=IF(LEFT(C23453)="9",19&LEFT(C23453,2))*1


--
Curalice
------------------------------------------------------------------------
Curalice's Profile:

http://www.excelforum.com/member.php...o&userid=28600
View this thread: http://www.excelforum.com/showthread...hreadid=502725