Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Combine Formula and static Text Beginer Excel Discussion (Misc queries) 2 August 23rd 05 06:31 AM
Formula to combine text? coal_miner Excel Worksheet Functions 5 August 18th 05 04:29 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"