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
