s why I said "I was expecting many replies from
you."
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: 11 August 2012 12:56
To: excel-macros@googlegroups.com
Subject
A couple of observations:
#1) "I was expecting many replies from you"
Many of us don't consider this a "game"
We're trying to help others with problems with their projects.
So, if it's simply a problem posed as a "challenge", I for one ignore it.
#2) You specifically said:
"I don’t think hel
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 10 August 2012 9:27
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ FW: Excel Formula challenge
>
> ** **
>
> This solution is provid
ust 2012 9:27
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge
This solution is provided on below link, incase of Excel Formula
http://www.mrexcel.com/forum/showthread.php?652427
On Fri, Aug 10, 2012 at 9:24 PM, NOORAIN ANSARI
wrote:
Dear Rajan,
You have al
[IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
>> *Sent:* 09 August 2012 8:30
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ FW:
to:
> excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI
> *Sent:* 09 August 2012 8:30
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ FW: Excel Formula challenge
>
> ** **
>
> Dear Rajan,
>
> ** **
>
> We can use it
@googlegroups.com
Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge
Dear Rajan,
We can use it..
Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
With Application.WorksheetFunction
rng = .Trim(.Substitute(rng, "|", ""))
For j = 1
Dear Rajan,
We can use it..
Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
With Application.WorksheetFunction
rng = .Trim(.Substitute(rng, "|", ""))
For j = 1 To Len(rng)
If VBA.Mid(rng, 1, 1) <> vbNullString Then
ch = VBA.Mid(rng, 1, 1)
rng =