Hi Dilip, Swapnal, Vidyut, Bala and Satish,
Thanks a million for your reply and solution!!
Regards,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on
Behalf Of TERTIUS KOSHY THOMAS
Sent: Monday, June 29,
Hi Thomas,
Your query has been solved and attached herewith. Thanks.
Thanks Regards
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS
Hi,
Please check the attached solution, let me know if it solves your query.
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of TERTIUS KOSHY THOMAS
Sent: 29 June 2009 06:52 am
To: excel-macros@googlegroups.com
Subject:
hi,
use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))1000,1,NA)
with regards
BALA
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video