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.
Regards
Vishal Parihar
On 11/5/10, Chandra Shekar <chandrashekarb....@gmail.com> wrote:
> 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
> <vish.pari...@gmail.com>wrote:
>
>> 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,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0,1,2,3,4,5,6,7,8,9")),LEN(A1))
>>
>> So, This is solution of :
>>
>> To Separate Data .
>> Excel Separate Two Words From A Cell In Two Cells.
>> Separate Text And Numbers.
>> Extract Number From Text String. Get Numbers From Alphanumeric.
>> Excel formulas to Separate data
>> Excel formulas to Split Data
>>
>> Regards
>> Vishal Parihar
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
> ----------------------------------------------------------------------------------
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Regards,
Vishal Parihar
Mob +919910415530
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Okey.xls
Description: MS-Excel spreadsheet
