Re: $$Excel-Macros$$ Extract last digit number

2012-02-27 Thread Shashidhara B
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

Re: $$Excel-Macros$$ Extract last digit number

2012-02-26 Thread Lokesh Loki
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:

$$Excel-Macros$$ Extract last digit number

2012-02-25 Thread Lokesh Loki
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,

Re: $$Excel-Macros$$ Extract last digit number

2012-02-25 Thread Lokesh Loki
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

Re: $$Excel-Macros$$ Extract last digit number

2012-02-25 Thread Maries
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: