Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Viper, Thanks for providing a very Nice formula Regards Prince On Wednesday, January 2, 2013 3:07:20 PM UTC+5:30, §»VIPER«§ wrote: =LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),))-1)SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),)),255), ,) this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal isk...@gmail.comjavascript: wrote: It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince...@gmail.com javascript: Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-...@googlegroups.com javascript: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Great day,* *viper* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Beginning to like it in this group. It works but would have preferred if text was returned also Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Phone: +256 752 954 723 For every domain you purchase from us, we host your website for the first 3 months for FREE! Manoj Kumar manoj.s...@gmail.com wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.com javascript:wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com**javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com** javascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.**com javascript:. Visit this group at http://groups.google.com/** group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Wow!! Thank you very much. Problem solved.. On Wednesday, 2 January 2013 14:10:36 UTC+5:30, Enrique Martin wrote: Replace the code with following one. Remember you are concatenating text and Numeric. Find attached the updated one Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String Dim myGet1 As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar Else myGet1 = myGet1 myChar End If Next iCount RemoveSpaces = myGet1 Space(1) myGet End Function On Wed, Jan 2, 2013 at 1:45 PM, Francis Mukobi franci...@gmail.comjavascript: wrote: Beginning to like it in this group. It works but would have preferred if text was returned also Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Phone: +256 752 954 723 For every domain you purchase from us, we host your website for the first 3 months for FREE! Manoj Kumar manoj...@gmail.com javascript: wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.comjavascript:wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com **javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcel 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
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Priyanka, You can refer some good e-books. Why don't you try this on bookboon.com. As a beginner you should go with Excel Bible, this will teach you not only excel basics but also VBA at initial stage. Regards, Anoop Sr. Developer On Wed, Jan 2, 2013 at 2:18 PM, Manoj Kumar manoj.s...@gmail.com wrote: Wow!! Thank you very much. Problem solved.. On Wednesday, 2 January 2013 14:10:36 UTC+5:30, Enrique Martin wrote: Replace the code with following one. Remember you are concatenating text and Numeric. Find attached the updated one Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String Dim myGet1 As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar Else myGet1 = myGet1 myChar End If Next iCount RemoveSpaces = myGet1 Space(1) myGet End Function On Wed, Jan 2, 2013 at 1:45 PM, Francis Mukobi franci...@gmail.comwrote: Beginning to like it in this group. It works but would have preferred if text was returned also Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Phone: +256 752 954 723 For every domain you purchase from us, we host your website for the first 3 months for FREE! Manoj Kumar manoj...@gmail.com wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.comjavascript:wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com** **javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcelhttps://www.facebook.com/**discussexcel
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Thanks Anoop Will come back to u after reading the books,if I don't get anything shall I ask u for better clarification Sent from my BlackBerry® smartphone from !DEA -Original Message- From: Anoop K Sharma aks.sharm...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 2 Jan 2013 14:26:36 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: how to remove space between numbers only. Hi Priyanka, You can refer some good e-books. Why don't you try this on bookboon.com. As a beginner you should go with Excel Bible, this will teach you not only excel basics but also VBA at initial stage. Regards, Anoop Sr. Developer On Wed, Jan 2, 2013 at 2:18 PM, Manoj Kumar manoj.s...@gmail.com wrote: Wow!! Thank you very much. Problem solved.. On Wednesday, 2 January 2013 14:10:36 UTC+5:30, Enrique Martin wrote: Replace the code with following one. Remember you are concatenating text and Numeric. Find attached the updated one Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String Dim myGet1 As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar Else myGet1 = myGet1 myChar End If Next iCount RemoveSpaces = myGet1 Space(1) myGet End Function On Wed, Jan 2, 2013 at 1:45 PM, Francis Mukobi franci...@gmail.comwrote: Beginning to like it in this group. It works but would have preferred if text was returned also Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Phone: +256 752 954 723 For every domain you purchase from us, we host your website for the first 3 months for FREE! Manoj Kumar manoj...@gmail.com wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.comjavascript:wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com** **javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi, Sorry for the long formula if sombody found somthing in short please let me know ;) If value is in cell A1 paste below code on cell A2 with Ctrl + Shift + Enter =REPLACE(A1,MATCH(1,N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),4,0)+1,MAX(N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),1*ROW(INDIRECT(1:LEN(A1-MATCH(1,N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),4,0),SUBSTITUTE(MID(A1,MATCH(1,N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),4,0),MAX(N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),1*ROW(INDIRECT(1:LEN(A1-MATCH(1,N(ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:LEN(A1))),4,0)+1), ,)) Regards, Lalit Mohan On Wednesday, 2 January 2013 13:25:54 UTC+5:30, Manoj Kumar wrote: Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.com wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com**javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com* *javascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.**com javascript:. Visit this group at http://groups.google.com/**
Fwd: $$Excel-Macros$$ Re: how to remove space between numbers only.
It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince141...@gmail.com Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-macros@googlegroups.com Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
=LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),))-1)SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),)),255), ,) this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal isk1...@gmail.com wrote: It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince141...@gmail.com Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-macros@googlegroups.com Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Great day,* *viper* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Nice formula viper but the last space is missing. On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: =LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),))-1)SUBSTITUTE(MID(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),)),255), ,) this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal isk...@gmail.comjavascript: wrote: It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince...@gmail.com javascript: Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-...@googlegroups.com javascript: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Great day,* *viper* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi lalit I don't find any need for that. just working as required by OP On Wed, Jan 2, 2013 at 3:15 PM, Lalit Mohan Pandey mohan.pande...@gmail.com wrote: Nice formula viper but the last space is missing. On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: =LEFT(A1,MIN(IFERROR(FIND({0,**1,2,3,4,5,6,7,8,9},A1),))-1)** SUBSTITUTE(MID(A1,MIN(**IFERROR(FIND({0,1,2,3,4,5,6,7,**8,9},A1),)),255), ,) this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal isk...@gmail.com wrote: It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince...@gmail.com Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-...@googlegroups.com Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- *Great day,* *viper* -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- *Great day,* *viper* -- 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
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Viper, No issue.. :) i am not pointing you just letting you know. thanks for the nice formula. Regards, Lalit Mohan On Thursday, 3 January 2013 09:49:40 UTC+5:30, §»VIPER«§ wrote: Hi lalit I don't find any need for that. just working as required by OP On Wed, Jan 2, 2013 at 3:15 PM, Lalit Mohan Pandey mohan.p...@gmail.comjavascript: wrote: Nice formula viper but the last space is missing. On Wednesday, 2 January 2013 15:07:20 UTC+5:30, §»VIPER«§ wrote: =LEFT(A1,MIN(IFERROR(FIND({0,**1,2,3,4,5,6,7,8,9},A1),))-1)** SUBSTITUTE(MID(A1,MIN(**IFERROR(FIND({0,1,2,3,4,5,6,7,**8,9},A1),)),255), ,) this should work with CSE On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal isk...@gmail.com wrote: It's absolutely working fine. Pravin Gunjal -- Forwarded message -- From: Prince prince...@gmail.com Date: Wed, Jan 2, 2013 at 11:20 AM Subject: $$Excel-Macros$$ Re: how to remove space between numbers only. To: excel-...@googlegroups.com Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- *Great day,* *viper* -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en
$$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince141...@gmail.com wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj.s...@gmail.com wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince141...@gmail.com wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Manoj -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.comjavascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Dear Manoj, If u want to remove only white space then use Substitute like given below. =SUBSTITUTE(A1, ,) Regards, Gawli Anil On Wed, Jan 2, 2013 at 12:15 PM, Prince prince141...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@**googlegroups.com. Visit this group at http://groups.google.com/** group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Thanks Regards, Gawli Anil Narayan Software Developer,
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Hi Anil, Monoj does not just required to remove with spaces. He wants to remove spaces from numeric value else everything is to keep intact. Regards Prince On Wednesday, January 2, 2013 12:22:27 PM UTC+5:30, अनिल नारायण गवली wrote: Dear Manoj, If u want to remove only white space then use Substitute like given below. =SUBSTITUTE(A1, ,) Regards, Gawli Anil On Wed, Jan 2, 2013 at 12:15 PM, Prince prince...@gmail.com javascript: wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@**googlegroups.com. Visit this group at http://groups.google.com/** group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/** discussexcel 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 post to this group, send email to excel-...@googlegroups.com. To unsubscribe from this group, send email to excel-macros...@** googlegroups.com. Visit this group at http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- 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 post to
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince141...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.comjavascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com javascript: wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.comjavascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.com javascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards, Manoj -- 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 post to this group, send email to excel-...@googlegroups.com javascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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)
Re: $$Excel-Macros$$ Re: how to remove space between numbers only.
Thanks Anoop. Solved My Problem. but it would be nice if formula also return the name along with phone number. On Wednesday, 2 January 2013 13:17:35 UTC+5:30, Enrique Martin wrote: Paste the following code in the module. this will extract all the numbers removing spaces. Please see the example in attached file. Function RemoveSpaces(str As String) As String Dim myLen As Long Dim myChar As String Dim myWrd As String Dim iCount As Integer Dim myGet As String myLen = Len(str) myWrd = str For iCount = 1 To myLen myChar = Mid$(myWrd, iCount, 1) If IsNumeric(myChar) Then myGet = myGet myChar End If Debug.Print myChar Next iCount RemoveSpaces = myGet End Function Regards, Anoop On Wed, Jan 2, 2013 at 1:01 PM, Prince prince...@gmail.com javascript:wrote: In this case we need to have a fomula that can count the existence of number in the text so in that case we need to modify this formula. that i let u know how. Regards Prince On Wednesday, January 2, 2013 12:54:34 PM UTC+5:30, Francis Mukobi wrote: What if it is a list of phone numbers and these numbers have different lengths? I mean some phone numbers are from India (10 digits ) and some numbers are from say Indonesia (14 digits ) etc. How do I remove spaces from such a list of numbers? Over to you Prince. Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net For every domain purchased from us, we host you for the first 3 months FREE! Prince prince...@gmail.com wrote: Hi Francis, This formula cut the string from first charactor up the number of numeric value inside that text i mean i have assumed that numeric value is a mobile number and every mobile number contains 10 digits in india so i cut the last 12 digit including space and concat that with first string that i got from left. Regards Prince On Wednesday, January 2, 2013 12:00:56 PM UTC+5:30, Francis Mukobi wrote: Could you please elaborate on the formula you have given, Prince? Francis Mukobi Frank Web Hosts Your affordable quality web hosts http://frankhost.net Manoj Kumar manoj...@gmail.com javascript: wrote: there is some text at end also. Sorry for inconvenience. On Wed, Jan 2, 2013 at 11:20 AM, Prince prince...@gmail.com**javascript: wrote: Hi Manoj, use this this may help you incase if the Number is any Mobile number: =MID(A1,1,LEN(A1)-12)**SUBSTITUTE(RIGHT(A1,12), ,) regards Prince On Wednesday, January 2, 2013 11:04:37 AM UTC+5:30, Manoj Kumar wrote: Hi, Is there any way out for removing spaces between numbers only. Spaces between the text should be removed. For example. Manoj Kumar 9015 408 078 Manoj Kumar 9015418078 The text at the front is not always fixed. It can contain any number text and spaces. Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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 post to this group, send email to excel-...@googlegroups.com** javascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.**com javascript:. Visit this group at http://groups.google.com/** group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en . -- Regards, Manoj -- Join official Facebook page of this forum @ https://www.facebook.com/**discussexcelhttps://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