word count -- LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1
On Fri, Feb 4, 2011 at 10:34 AM, NOORAIN ANSARI wrote:
> Dear Jorge,
>
> Please try..
>
> *For Letter Counting=Len(A1)*
> *For Word Counting=Len(A1)-Substitute(Len(A1)+1*
>
> Thanks & regards,
> Noorain Ansari
> On Fri, Feb 4, 2011 at 1:17 AM,
Dear Jorge,
Please try..
*For Letter Counting=Len(A1)*
*For Word Counting=Len(A1)-Substitute(Len(A1)+1*
Thanks & regards,
Noorain Ansari
On Fri, Feb 4, 2011 at 1:17 AM, Jorge Marques wrote:
> Hi, is there anyway of counting words ou letters in a specific cell?thank
> you very much
>
>
> --
>
>
Hi, is there anyway of counting words ou letters in a specific cell?thank
you very much
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Use the attached sheet..
This can be done through VBA.. I have used the code provided by Yogesh
Gupta's blog :-
http://www.yogeshguptaonline.com/2009/07/excel-functions-convert-numbers-into.html
Regards,
Manoj Kumar
On Thu, Feb 3, 2011 at 4:44 PM, solomon raju wrote:
> Hi All,
>
> Please fi
With all the fanasty/real sport stuff it would be nice to have a schedule
generator that could do the games with home/away function.
Thanks,
David
--- On Thu, 2/3/11, Ayush wrote:
From: Ayush
Subject: $$Excel-Macros$$ Submit Excel idea or suggestion !
To: excel-macros@googlegroups.com
Date:
Congratulations Ashish!!
His posts motivated me to learn more And I've learned a lot.
Thanks
On Feb 2, 9:55 am, Ayush wrote:
> Ashish Koul has been selected as *'Most Helpful Member'* for the month of
> Jan 2011.
> He has posted over 75 posts (11% of total posts) in January 2011 and helped
>
GITS Academy in malleshwaram is good.
On Wed, Feb 2, 2011 at 2:37 AM, Puttu * wrote:
> Your suggetion is much appriciateable
>
>
> On Wed, Feb 2, 2011 at 9:30 AM, Puttu * wrote:
>
>> Hi Experts,
>>
>> Required your advise on VBA training, I am looking for VBA best training
>> in Basavanagude or
Dear members,
Time to think !
I am collecting ideas and new features that you would like to see in
upcoming version of MS Excel.
The only intent here is to make excel awesome for the users and give
feedback to Microsoft on their product.
http://goo.gl/mod/psLh
My Target is to collect 1000+ id
I want to print specific user define pages from all selected sheets. I
have created a userform with 2 text boxes which the user enters the
page number range
However I can not figure how to get the returned value into my
sht.printout statement
And will this only print the selected workseets or all t
can you attach the sample file
On Thu, Feb 3, 2011 at 4:54 PM, lifeactuary wrote:
> Class 1 2
> 3 456 7
> 8 91011
> Priority1
> 7 4
Thank you Umesh for helping me with the solution ...
I use Excel 2007 in Spanish.
Regards
Hector Ruiz
2011/2/3 Umesh Dev
> Hi Hector,
>
> Change the formula to IF(ISBLANK(D2),(B2-A2)*24,(D2-B2)*24) in the vba you
> have mentioned is esblanco
>
>
> Regards
> Umesh Dev
>
> On Thu, Feb 3, 20
Send an email to "excel-macros@googlegroups.com" and attach your file.
Use the subject for the title of your post.
On Feb 2, 1:59 am, Bhushan wrote:
> Hi Expert,
>
> PLease assist me how can attach sample excel file to the new post.
>
> There is no link avaliable which can upload my sample file f
Class 1 2
3 456 7
8 91011
Priority1
7 4 116 3
3 1 2
RevisedPriority
I have a table of data containing name and time information. Excel and
Access can understand it whilst it is in a format such as 12.2 or 11.8
but when it is in a minutes format it cannot.
For example I have a macro which I am still working on which will tidy
up an rtf to be a table recognisable an
Hi All,
Please find the attached excel file and give me some formula to convert the
amount in text.
Regards,
Solomon
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
h
Consider the following table:
Class1
Priority
RevisedPriority
The row "Priority" represents the values actually chosen.
No selection was made for Class 1 or Class10
Priority1 was duplicated for Class 2 and Class 9
Priority3 was duplicated for Class 7 and Class 8
Priority 5,8,9, & 10 were left ou
Here is the solution, if anyone would benefit from this:
---
Sub Delete_Empty()
Application.ScreenUpdating = False
Dim a As Range
Dim SrchRnga
Set SrchRnga = ActiveSheet.Range("D1",
ActiveSheet.Range("D10
Hi Ayush,
I can help on content development time to time.
Congrats!
Cecilia
On Feb 2, 10:39 am, Ayush wrote:
> Hello everyone,
>
> I am glad to share that I have decided to launch an excel knowledge website
> for this group.The website will be launched on 4th anniversary of this group
> i.e.
Ashish Koul
I am using MS outlook, I want to use as attachment since they need to put
the balance amount in the receiving co TAB and also comments.
Thanks for looking into my requirement.
Thanks
Jagadeesh
On Thu, Feb 3, 2011 at 2:12 PM, ashish koul wrote:
> you want to send range as a
Hi,
I think that mm will return 02, while m will return 2
Regards - Dave
From: anil.bha...@tatacommunications.com
To: excel-macros@googlegroups.com
Date: Thu, 3 Feb 2011 14:02:16 +0530
Subject: RE: $$Excel-Macros$$ HOW TO CONVERT DATE IN TEXT WITH FOMULA
Hi Aamir,
Please see the differ
Hi Aamir,
Please see the difference in formatting of text.
Mmmm will give you February
Mmm will give you Feb
Mm will give you 2
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Aamir Shahza
you want to send range as attachment also
r u using outlook or notes
On Thu, Feb 3, 2011 at 12:16 PM, Jagadeesh B S wrote:
> Hello friends.
>
> Can any one help me on this?
>
> Thanks in advance
> Jagadeesh B S
>
> On Wed, Feb 2, 2011 at 5:30 PM, Jagadeesh B S wrote:
>
>> Hello friends I
check out this link
http://www.techonthenet.com/excel/formulas/text.php
http://office.microsoft.com/en-us/excel-help/text-HP005209313.aspx?CTT=5&origin=HP005203209
On Thu, Feb 3, 2011 at 12:20 PM, hanumant shinde
wrote:
> hi Rohan,
>
> that was cool. good info even though it was asked for month
Thank you all...
On Thu, Feb 3, 2011 at 12:36 PM, Umesh Dev wrote:
> congrats Ashish
>
>
> Regards
> Umesh Dev
>
> On Wed, Feb 2, 2011 at 8:25 PM, Ayush wrote:
>
>> Ashish Koul has been selected as *'Most Helpful Member'* for the month
>> of Jan 2011.
>> He has posted over 75 posts (11% of to
24 matches
Mail list logo
