to make it precise,
=if(ISERROR(SEARCH(" ",A1)),LEN(A1),SEARCH(" ",A1)-1)
With best regards,
Vignesh
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: Wednesday, May 12, 2010 3:59 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ URGENT Request
Hi,
Assuming there is a space after the first name, look for that space using
search, then subtract 1:
=SEARCH(" ",A1)-1
Change the A1 ref to suit your data.
Regards - Dave.
_____
From: azhar....@gmail.com
Date: Wed, 12 May 2010 14:33:26 +0500
Subject: $$Excel-Macros$$ URGENT Request
To: excel-macros@googlegroups.com
Hi Members
I have an excel sheet with huge text data and at the beginning of each cell
text string there are names (mostly single names) I want to count the number
of letters in the first word (that is the name I referred to above). Please
tell some excel function that does this work for me.
Thanks and regards in advance for urgent replies.
AZHAR RAI
Cell: +92 333-552-7731
Skype: azhar.rai
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<http://exceldailytip.blogspot.com/>
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
_____
Find it on Domain.com.au Need a new place to live?
<http://clk.atdmt.com/NMN/go/157631292/direct/01/>
--
----------------------------------------------------------------------------
------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about
the learning and support from the group.Let friends and co-workers know they
can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
