please unsubscribe the posts
From: Maries talk2mar...@gmail.com
To: excel-macros@googlegroups.com
Sent: Saturday, February 25, 2012 10:04 PM
Subject: Re: $$Excel-Macros$$ Extract last digit number
My Try:
=MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1
Hi Maries,
Thanks for sending the valuable formula. Thanks a lot maries.
Regards
Lokesh.M
On Sat, Feb 25, 2012 at 10:04 PM, Maries talk2mar...@gmail.com wrote:
My Try:
=MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1)
On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote:
Hi All,
I need a formula to extract 20 only form the below text and fix the same in
to next cell.
Canada_20120223_E002_E001(20)
regards
Lokesh.M
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Hi Sam,
Thank you very much for sending the formula.
Regards
Lokesh.M
On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=SUBSTITUTE(REPLACE(A1,1,FIND((,A1),),),)
Regards,
Sam Mathai Chacko
On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki
My Try:
=MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1)
On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote:
Hi Sam,
Thank you very much for sending the formula.
Regards
Lokesh.M
On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko samde...@gmail.comwrote: