Guys I am very Sorry for turning up very late and giving you an alarm with respect to that all the above formula will not work if we found any alphanumeric string
Lets take an example if we have appended string then the above formula will not work. "Hello my 9711 no is in 77 alpha numeric 2297 string, and my 14 home address is 49" Sorry Dave and Harmeet ! Regards, Rahul Gandhi +91-9711772297 On Apr 1, 4:15 pm, Dipika Mallya <blraspirants...@gmail.com> wrote: > Great point Paul, > > @Abhi > > To add to Paul's Excell insight with a working example, > > Suppose two functional links.http://j.mp/gate2010csithttp://j.mp/gate2010cs > exist > > Does your function need to identify the csit link from the cs link or not. > > Regards, > > DMhttp://anonomi.com/inamehttp://anonomi.com/DM > > On Wed, Mar 31, 2010 at 2:24 AM, paulwillekens < > > paul.johan.willek...@gmail.com> wrote: > > Hi Abhidha, > > > Please specify what the result is you look for... > > is it jdsdnc versus 2123 versus asdd ... or only extraction of the > > number 2123 ? > > is it iofruif versus 68732 versus fnw ... or simply 68732 ? > > do digits appear separated by alphabetical characters on some > > occasions or never? > > > As soon as I get that cleared out, I'll send you the routine you > > need... > > > Greetings, > > > Paul Willekens > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our Facebook Group @ > >http://www.facebook.com/group.php?gid=287779555678 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > We reach over 6,800 subscribers worldwide and receive many nice notes about > > the learning and support from the group.Let friends and co-workers know they > > can subscribe to group at > >http://groups.google.com/group/excel-macros/subscribe > > > To unsubscribe, reply using "remove me" as the subject. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
