Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-05-07 Thread Rahul Gandhi.
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 st

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-04-01 Thread Dipika Mallya
Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links. http://j.mp/gate2010csit http://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DM http://anonomi.com/iname http://anonomi.co