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
t;
>
> On Thu, May 6, 2010 at 6:15 PM, anand shivappa
> wrote:
> > Please help out. I got struct here.
> >
> >
> >
> > On Thu, May 6, 2010 at 5:45 PM, anand shivappa >
> > wrote:
> >>
> >> Hi Everyone,
> >>
> >> I
have '~' character in them if they
> have then change this character in formula with one which is absent in
> your text.
>
> Thanks & Regards
> Sandeep
>
>
> On Fri, May 7, 2010 at 3:36 PM, anand shivappa
> wrote:
> > I am fine buddy.
> >
If (Mid(Str, i, 1)) <> " " Then
>>> NumStr1 = Mid(Str, i, 1) & NumStr1
>>>
>>> Else
>>> Exit For
>>>
>>> End If
>>> Next i
>>> exright = NumStr1
>>> End Function
(Mid(Str, i, 1)) <> " " Then
> NumStr1 = Mid(Str, i, 1) & NumStr1
>
> Else
> Exit For
>
> End If
> Next i
> exright = NumStr1
> End Function
>
>
>
>
> On Thu, May 6, 2010 at 6:15 PM, anand shivappa
> wrot
Please help out. I got struct here.
On Thu, May 6, 2010 at 5:45 PM, anand shivappa wrote:
> Hi Everyone,
>
> I need to extract a rightmost word in a line through excel functions.
>
> Like USA Street is having no 10. I need to extract the last word like 10.
>
> Please help
Hi Everyone,
I need to extract a rightmost word in a line through excel functions.
Like USA Street is having no 10. I need to extract the last word like 10.
Please help me out.
Thanks and Regards,
Anand S
--
When everything fails Patience will win
--
-
Import the text file to Access.
Then based on the criteria, Import the records to Excel.
thanks and Regards,
Anand
On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote:
> Dear All,
>
> Need ur advise...
>
> I got around 20 text files in a day,which had 13 to 15 columns separated by
> "|" this sign.
