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
I don't know why you guy's are getting surprised for this one =-O .
Because any of you can create lot more like this by just inserting any
of your flash files in excel.
*Whatever the magic is happening is just a shadow of the flash files and
excel is just a window which holds it :-P *
Same t
Happy Birthday big bro
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: koul.ash...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 1 Jan 2013 18:43:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Happy b'day Noorain Ansar
Happy birthday bro! and wish you a very happy new year ahead.
On Wed, Jan 2, 2013 at 10:51 AM, Anoop K Sharma wrote:
> Happy B'day Noorain...
>
>
> On Wed, Jan 2, 2013 at 10:50 AM, Rajan_Verma wrote:
>
>> HI Noorain .
>> wish you a great New year and Happy b day,
>> have a great year ahea
Hi Noorain Sir,
Wish you a many many happy returns of the day & very very happy JANMDIN.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789,9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this
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
Happy Birth Day.Cheers :)
Regards,
Amol Shrivastava
On Wed, Jan 2, 2013 at 12:27 PM, Rajasekhar Praharaju <
rajasekhar.prahar...@gmail.com> wrote:
> Happy birthday Noor have a delightful nd colourful moments a head.
> On Jan 2, 2013 12:25 AM, "Umesh Soni" wrote:
>
>> Happy birthday Noorain
Happy birthday Noor have a delightful nd colourful moments a head.
On Jan 2, 2013 12:25 AM, "Umesh Soni" wrote:
> Happy birthday Noorain.. May All u r wishes comes true have a great
> Year Ahead.
>
> Regards,
>
> Umesh Soni
>
> On Tue, Jan 1, 2013 at 7:43 PM, wrote:
>
>> Happy b'day
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
Hi Dhaval,
i have created something for you, may be it can help you,
Download the heat map from here
http://www.excelfox.com/forum/f20/heat-map-739/
Regards
Rajan verma
On Monday, 31 December 2012 12:25:09 UTC+5:30, Dhaval Shah wrote:
>
>
> *HELLO EXPERTS ANY SOLUTIONS ??*
>
>
> -- Forw
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.
Nice collection Amarthanks to share with us.
On Tue, Jan 1, 2013 at 4:16 PM, amar takale wrote:
> Dear my all Excel Group Members,
>
> I found Excel fun Video on Internet while searching Excel Solution & I
> like very much.I hope you all like it fun Video.So I attached this
> Excel.
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 of
Hi Praveen,
just send a blank mail on
excel-macros...@googlegroups.com.
regards
Prince
On Wednesday, January 2, 2013 10:25:09 AM UTC+5:30, MITS wrote:
>
> Please do the needful.
>
> --
> Regards,
>
> Praveen Golash
>
>
--
Join official Facebook page of this forum @
https://www.facebook.c
Happy B'day Noorain...
On Wed, Jan 2, 2013 at 10:50 AM, Rajan_Verma wrote:
> HI Noorain .
> wish you a great New year and Happy b day,
> have a great year ahead
>
> Regards
> Rajan verma
>
> On Wednesday, 2 January 2013 00:13:59 UTC+5:30, ashish wrote:
>>
>> Happy b'day Noorain Ansari
>>
Send mail to below link
excel-macros+unsubscr...@googlegroups.com.
On Wed, Jan 2, 2013 at 10:25 AM, Praveen Golash wrote:
> Please do the needful.
>
> --
> Regards,
>
> Praveen Golash
>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
HI Noorain .
wish you a great New year and Happy b day,
have a great year ahead
Regards
Rajan verma
On Wednesday, 2 January 2013 00:13:59 UTC+5:30, ashish wrote:
>
> Happy b'day Noorain Ansari
>
>
> Regards
> Ashish Koul
> Sent on my BlackBerry® from Vodafone
--
Join official Facebook page
Please do the needful.
--
Regards,
Praveen Golash
--
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
On Wed, Jan 2, 2013 at 9:47 AM, अनिल नारायण गवली wrote:
> Dear Noorian,
>
> Wish U a very happy birthday:) Mag God bless u.
>
>
> Thanks,
> Gawli Anil
>
--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join official Faceb
Dear Noorian,
Wish U a very happy birthday:) Mag God bless u.
Thanks,
Gawli Anil
On Wed, Jan 2, 2013 at 8:37 AM, Prince wrote:
> Happay b. day Noorain Bhai. May god bless you lots of happiness ahead.
>
> Regards
> Prince
>
>
>
>
> On Wednesday, January 2, 2013 12:13:5
Happay b. day Noorain Bhai. May god bless you lots of happiness ahead.
Regards
Prince
On Wednesday, January 2, 2013 12:13:59 AM UTC+5:30, ashish wrote:
>
> Happy b'day Noorain Ansari
>
>
> Regards
> Ashish Koul
> Sent on my BlackBerry® from Vodafone
--
Join official Facebook page of this
*Wish you a very happy B'Day Noorain*
On Wednesday, 2 January 2013 00:13:59 UTC+5:30, ashish wrote:
>
> Happy b'day Noorain Ansari
>
>
> Regards
> Ashish Koul
> Sent on my BlackBerry® from Vodafone
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
Happy birthday Noorain.. May All u r wishes comes true have a great
Year Ahead.
Regards,
Umesh Soni
On Tue, Jan 1, 2013 at 7:43 PM, wrote:
> Happy b'day Noorain Ansari
>
>
> Regards
> Ashish Koul
> Sent on my BlackBerry® from Vodafone
>
> --
> Join official Facebook page of this fo
Happy b'day Noorain Ansari
Regards
Ashish Koul
Sent on my BlackBerry® from Vodafone
--
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 Probl
Hi Kasper,
Dear instead of giving solution i just want to give the idea required to
accomplish your task.just follow the below mentioned steps and it help you
to do it from your own.
1:Select the columns of employee name .
2:click : Data Tab
3: Spot the option : Remove duplicate
4: it will ask
Hi Sabosis,
Please replace your formula with below one.
ActiveCell.Formula = Time + TimeSerial(2, 55, 0)
Regards,
Anoop
Sr. Developer
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
Hi Rajesh,
PFA,
Regards,
Anoop
On Tue, Jan 1, 2013 at 6:30 PM, Rajesh thrissur
wrote:
>
>
>
>
> Hi Experts,
>
> Please refer the attached file & tell me
> How to select employee names from the column "B" and display in Column "D"
> after removing the duplicate.
>
> Regards
> Rajesh
>
> --
> J
Hi Experts,
Please refer the attached file & tell me
How to select employee names from the column "B" and display in Column "D"
after removing the duplicate.
Regards
Rajesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accura
too good.
Wish you a very happy new year...
On Tue, Jan 1, 2013 at 4:16 PM, amar takale wrote:
> Dear my all Excel Group Members,
>
> I found Excel fun Video on Internet while searching Excel Solution & I
> like very much.I hope you all like it fun Video.So I attached this
> Excel.Enjoy every
Cool and Nice :)
Regards
Prince
On Tuesday, January 1, 2013 4:16:52 PM UTC+5:30, amar takale wrote:
>
> Dear my all Excel Group Members,
>
> I found Excel fun Video on Internet while searching Excel Solution & I
> like very much.I hope you all like it fun Video.So I attached this
> Excel.Enjo
Animation rocks
On Tuesday, 1 January 2013 16:16:52 UTC+5:30, amar takale wrote:
>
> Dear my all Excel Group Members,
>
> I found Excel fun Video on Internet while searching Excel Solution & I
> like very much.I hope you all like it fun Video.So I attached this
> Excel.Enjoy every excel use
Hi Rashid,
Sorry for that i will send you the file by today evening itself
Regards,
Lalit Mohan
On Tuesday, 1 January 2013 13:37:21 UTC+5:30, prkhan56 wrote:
>
> Hello Lalit
> I cannot see the complete code. If I go and check the original and paste
> the code I get lot of unwanted characters in
Welcome Francis
On Tuesday, January 1, 2013 2:03:51 PM UTC+5:30, Francis Mukobi wrote:
>
> I am called Francis Mukobi. Am an IT Manager who is deeply in love with
> computer programming. Am here to learn from you and perhaps impart what I
> have.
>
>
> Francis Mukobi
> Business Development
> Fr
I am called Francis Mukobi. Am an IT Manager who is deeply in love with
computer programming. Am here to learn from you and perhaps impart what I have.
Francis Mukobi
Business Development
Frank Web Hosts
http://frankhost.net
Phone : +256 752 954 723
--
Join official Facebook page of this foru
Hello Lalit
I cannot see the complete code. If I go and check the original and paste
the code I get lot of unwanted characters in the code
If you cannot send me in a file then can you please send the code to me as
a text file.
thanks for your time and help
Rashid Khan
On Monday, December 31, 2
40 matches
Mail list logo
