)),255),"
>
> ","")
>
> this should work with CSE
>
> On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal
> > wrote:
>
>> It's absolutely working fine.
>>
>> Pravin Gunjal
>>
>>
>> ------ Forwarded message -
ravin Gunjal wrote:
>>>
>>>> It's absolutely working fine.
>>>>
>>>> Pravin Gunjal
>>>>
>>>>
>>>> -- Forwarded message --
>>>> From: Prince
>>>> Date: Wed, Jan 2, 2
Jan 2, 2013 at 2:55 PM, Pravin Gunjal wrote:
>>
>>> It's absolutely working fine.
>>>
>>> Pravin Gunjal
>>>
>>>
>>> -- Forwarded message --
>>> From: Prince
>>> Date: Wed, Jan 2, 2013 at 11:20 AM
>>> Subject
> ","")
>
> this should work with CSE
>
> On Wed, Jan 2, 2013 at 2:55 PM, Pravin Gunjal
> > wrote:
>
>> It's absolutely working fine.
>>
>> Pravin Gunjal
>>
>>
>> ------ Forwarded message ------
>> From: Pri
g fine.
>
> Pravin Gunjal
>
>
> -- Forwarded message --
> From: Prince
> 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,
>
>
It's absolutely working fine.
Pravin Gunjal
-- Forwarded message --
From: Prince
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 i
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:"&
6
To:
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 e
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 wrote:
> Wow!
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
>
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
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 th
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
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 Host
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
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 wrote:
> Hi Francis,
>
> This formula cut the string from first charactor up the number of numeric
> value inside that text
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 stri
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 wrote:
>there is some text at end also. Sorry for inconvenience.
>
>
>On Wed, Jan 2, 2013 at 11:20 AM, Prince wrote:
>
>> Hi Ma
there is some text at end also. Sorry for inconvenience.
On Wed, Jan 2, 2013 at 11:20 AM, Prince 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
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.
20 matches
Mail list logo
