You can simply use a formula like: =IF(A2<>"",SUBSTITUTE(TEXT(A2,"0-000-000-000"),"919-","9-"),"") and copy down/across. Why do you want a macro? Do you know how to write macros? If not, then you're asking one of us to write it for you, you'll have to provide much more information. How many rows of data? How many columns? What do you want to do with the resulting text string? What do you want to do with the original data? How do you expect to maintain it?
Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- From: my excel <myxlg...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Wednesday, August 6, 2014 8:01 AM >Subject: Re: $$Excel-Macros$$ make 10 digit data > > > >is any solution from expert....? > > > >On Tue, Aug 5, 2014 at 12:52 PM, my excel <myxlg...@gmail.com> wrote: > >just copy paste data to excel >> >> >>if i select A column data hit on button A column data convert in to 10 digit >>no....... >> >> >> >>i want data as text also convert in to number & it must be 10 digit mobile no >> >> >>remove 91 >>remove 0 >>using = right 10 >>want in macro button >> >> >> >>On Mon, Aug 4, 2014 at 2:03 PM, Vaibhav Joshi <v...@vabs.in> wrote: >> >>hi >>> >>> >>>you can do it without macro by changing cell format to number format. >>> >>> >>>Cheers!! >>> >>> >>> >>>On Sun, Aug 3, 2014 at 9:36 PM, my excel <myxlg...@gmail.com> wrote: >>> >>>Sir, >>>>i have a excel file its contains customer mobile no >>>> >>>> >>>>ex: >>>> >>>> >>>>Jan Feb Mar …. ….. etc >>>>919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 >>>>9.19845E+11 09595959595 +919449449460 9845098430 >>>>9845098430 94949494949 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>>Q: how to convert to 10 digit mobile no ? >>>>i used =right ( but some in text format pls make useful macro 4 me >>>>selecting A column i can make it 10 digit, by selecting B column i can make >>>>it 10 digit, selecting Z column i can make it 10 digit >>>> >>>> >>>> >>>> >>>>thanks in advance -- >>>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>https://www.facebook.com/discussexcel >>>> >>>>FORUM RULES >>>> >>>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>>will not get quick attention or may not be answered. >>>>2) Don't post a question in the thread of another member. >>>>3) Don't post questions regarding breaking or bypassing any security >>>>measure. >>>>4) Acknowledge the responses you receive, good or bad. >>>>5) Jobs posting is not allowed. >>>>6) Sharing copyrighted material and their links is not allowed. >>>> >>>>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>>>members are not responsible for any loss. >>>>--- >>>>You received this message because you are subscribed to the Google Groups >>>>"MS EXCEL AND VBA MACROS" group. >>>>To unsubscribe from this group and stop receiving emails from it, send an >>>>email to excel-macros+unsubscr...@googlegroups.com. >>>>To post to this group, send email to excel-macros@googlegroups.com. >>>>Visit this group at http://groups.google.com/group/excel-macros. >>>>For more options, visit https://groups.google.com/d/optout. >>>> >>> >>>-- >>>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >>>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>https://www.facebook.com/discussexcel >>> >>>FORUM RULES >>> >>>1) Use concise, accurate thread titles. Poor thread titles, like Please >>>Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >>>not get quick attention or may not be answered. >>>2) Don't post a question in the thread of another member. >>>3) Don't post questions regarding breaking or bypassing any security measure. >>>4) Acknowledge the responses you receive, good or bad. >>>5) Jobs posting is not allowed. >>>6) Sharing copyrighted material and their links is not allowed. >>> >>>NOTE : Don't ever post confidential data in a workbook. Forum owners and >>>members are not responsible for any loss. >>>--- >>>You received this message because you are subscribed to the Google Groups >>>"MS EXCEL AND VBA MACROS" group. >>>To unsubscribe from this group and stop receiving emails from it, send an >>>email to excel-macros+unsubscr...@googlegroups.com. >>>To post to this group, send email to excel-macros@googlegroups.com. >>>Visit this group at http://groups.google.com/group/excel-macros. >>>For more options, visit https://groups.google.com/d/optout. >>> >> > >-- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >1) Use concise, accurate thread titles. Poor thread titles, like Please Help, >Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get >quick attention or may not be answered. >2) Don't post a question in the thread of another member. >3) Don't post questions regarding breaking or bypassing any security measure. >4) Acknowledge the responses you receive, good or bad. >5) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
