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
