Thanks a lot Vigooo. You have solved my problem. Thanks again and again.
AZHAR RAI
Cell: 0333-552-7731
Skype: azhar.rai
On 13 May 2010 10:10, Vigooo <nv1...@gmail.com> wrote:
> 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
> 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
> ------------------------------
>
> 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
>
--
----------------------------------------------------------------------------------
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
