Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-14 Thread vikas gupta
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-12 Thread anand shivappa
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-11 Thread Vikas Chouhan
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-11 Thread vikas gupta
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-10 Thread anand shivappa
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. > >

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-10 Thread Sandeep Kumar Maurya
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread anand shivappa
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 > > >

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread Vikas Chouhan
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

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-07 Thread anand shivappa
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 >

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-06 Thread P.VIJAYKUMAR
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:

Re: $$Excel-Macros$$ Re: Extract Right Word in Line

2010-05-06 Thread ashish koul
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,