hi
sorry about that command
we can use "right" command for that
regards
vikas
On Wed, May 12, 2010 at 9:19 AM, anand shivappa
wrote:
> Can you send me the code for RTRIM it.
>
> Because I cannot find in Excel function list.
>
> Thanks and Regards,
> Anand S
>
>
>
> On Tue, May 11, 2010 at 6:10
Can you send me the code for RTRIM it.
Because I cannot find in Excel function list.
Thanks and Regards,
Anand S
On Tue, May 11, 2010 at 6:10 PM, vikas gupta wrote:
> HI ANAND
>
> YOU CAN USE "RTRIM" COMMAND
>
> REGARDS
> VIKAS GUPTA
> 9311334683
>
>
>
> On Thu, May 6, 2010 at 6:15 PM, anand
hi how to use the command pls ex plane
On Tue, May 11, 2010 at 6:10 PM, vikas gupta wrote:
> HI ANAND
>
> YOU CAN USE "RTRIM" COMMAND
>
> REGARDS
> VIKAS GUPTA
> 9311334683
>
>
>
> On Thu, May 6, 2010 at 6:15 PM, anand shivappa
> wrote:
> > Please help out. I got struct here.
> >
> >
> >
> > On
HI ANAND
YOU CAN USE "RTRIM" COMMAND
REGARDS
VIKAS GUPTA
9311334683
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 need to extract a rightmost word in a lin
Dear Sandeep,
Thanks for your solution.
It is a great help you have done to me.
Thanks and Regards,
Anand S
On Mon, May 10, 2010 at 8:42 PM, Sandeep Kumar Maurya wrote:
> Hi Anand,
>
> You are right, that Asish solution is perfect,
> but if you don't want to use VBA you can use this one.
>
>
Hi Anand,
You are right, that Asish solution is perfect,
but if you don't want to use VBA you can use this one.
=RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1,"
","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")
Don't see its size, because it is smallest possible using formula.
And I assume that your text d
I am fine buddy.
If it is more than 5 words in a cell how will you extract the right word.
Probably Ashish has sent was the perfect solution for it.
Thanks and Regards,
Anand S
On Fri, May 7, 2010 at 9:49 AM, Vikas Chouhan wrote:
> hi anand how are you
>
>
>
hi anand how are you
AB
1 vikas kumar =right(A1,LEN(A1)-FIND(" ",A1) RESULT IS "KUMAR"
On Thu, May 6, 2010 at 9:39 AM, P.VIJAYKUMAR wrote:
> Use the function RIGHT(Select the whole text in which the textor the thing
> which you
Thanks Ashish. You have cleared my burden.
Thanks a ton.
Thanks and Regards,
Anand S
On Thu, May 6, 2010 at 9:22 PM, ashish koul wrote:
> Public Function exright(Str)
> Dim i, NumStr1
> NumStr1 = ""
>
> For i = Len(Str) To 1 Step -1
> If (Mid(Str, i, 1)) <> " " Then
>
Use the function RIGHT(Select the whole text in which the textor the thing
which you want is there,number of characters which you want from the text)
Ex: If a Cell B2 ContainsTIGER999 .Use the function = RIGHT(B2,3) to get
the required 999 as the answer.
On Thu, May 6, 2010 at 9:
Public Function exright(Str)
Dim i, NumStr1
NumStr1 = ""
For i = Len(Str) To 1 Step -1
If (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,
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 me out.
>
>
> Thanks
12 matches
Mail list logo
