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 anand.shiva...@gmail.com 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,

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 vikas.63...@gmail.com wrote: HI ANAND YOU CAN USE RTRIM COMMAND REGARDS VIKAS GUPTA 9311334683 On Thu, May 6, 2010 at 6:15

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 anand.shiva...@gmail.com wrote: Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.com wrote: Hi Everyone, I need to

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 vikas.63...@gmail.com wrote: HI ANAND YOU CAN USE RTRIM COMMAND REGARDS VIKAS GUPTA 9311334683 On Thu, May 6, 2010 at 6:15 PM, anand shivappa anand.shiva...@gmail.com wrote: Please help out. I got

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 don't have

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 koul.ash...@gmail.com wrote: Public Function exright(Str) Dim i, NumStr1 NumStr1 = For i = Len(Str) To 1 Step -1 If (Mid(Str, i, 1))

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 vijay.4...@gmail.com wrote: Use the function RIGHT(Select the whole text in which the textor the

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 vikask...@gmail.com wrote: hi anand how are

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

2010-05-06 Thread anand shivappa
Please help out. I got struct here. On Thu, May 6, 2010 at 5:45 PM, anand shivappa anand.shiva...@gmail.comwrote: 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

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, anand

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