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
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
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,