Re: $$Excel-Macros$$ Excel Formula for Separation of integer in Single cell.

2010-11-05 Thread vishal parihar
Hi, The attachment is the solution of your Problem. What i have sent you it's just a way to gather information and location of integer value in cell. And one more thing to Chandra don't mag,up excel formula,Understand them. After it work Once you understand the formula and how to use it. Regar

Re: $$Excel-Macros$$ Excel Formula for Separation of integer in Single cell.

2010-11-05 Thread Chandra Shekar
Hi, Nice formula but its not working with this data a 958 b 951 will return same value is there any way to do this. Thanks Chandra Shekar On Wed, Nov 3, 2010 at 7:48 PM, Vishal Parihar wrote: > Hi All, > > Today i am going to show that how we can separation of integer > in single cell by

$$Excel-Macros$$ Excel Formula for Separation of integer in Single cell.

2010-11-03 Thread Vishal Parihar
Hi All, Today i am going to show that how we can separation of integer in single cell by using excel function. if data in cell like |vishal parihar 9910415530| or |vishal parihar 9910415530 vishal parihar| by using below function one, Output like this |9910415530|. Function One : =MID(A1,