t;
>
>
>
> 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: $$Exce
ros@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 M
can you please share the example of your query
On May 12, 2:33 pm, Azhar Rai wrote:
> 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 t
Hi Azhar,
You can use LEN(the cell address) function.
Thanks and Regards,
Anand S
On Wed, May 12, 2010 at 3:03 PM, Azhar Rai wrote:
> 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 coun
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-mac
