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
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
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
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
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
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
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
-- 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
, 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
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
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
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
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,
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
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
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
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
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
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
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
20 matches
Mail list logo