Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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 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 and Regards, >> >> Anand S >> >> >> >> >> >> -- >> >> When everything fails Patience will win >> > >> > >> > >> > -- >> > When everything fails Patience will win >> > >> > -- >> > >> > -- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 6,800 subscribers worldwide and receive many nice notes >> > about >> > the learning and support from the group.Let friends and co-workers know >> > they >> > can subscribe to group at >> > http://groups.google.com/group/excel-macros/subscribe >> > >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe > > > > -- > When everything fails Patience will win > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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 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 > > > > > > > > -- > > When everything fails Patience will win > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 6,800 subscribers worldwide and receive many nice notes > about > > the learning and support from the group.Let friends and co-workers know > they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- When everything fails Patience will win -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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 and Regards, > >> Anand S > >> > >> > >> -- > >> When everything fails Patience will win > > > > > > > > -- > > When everything fails Patience will win > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 6,800 subscribers worldwide and receive many nice notes > about > > the learning and support from the group.Let friends and co-workers know > they > > can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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 > > > > -- > When everything fails Patience will win > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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. > > =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 '~' 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 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 > >> > >> > >>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 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: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 > 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 > 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 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 > > > > > > > > -- > > When everything fails Patience will win > > > > -- > > > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > HELP US GROW !! > > > > We reach over 6,800 subscribers worldwide and receive many nice notes > > about the learning and support from the group.Let friends and > co-workers > > know they can subscribe to group at > > http://groups.google.com/group/excel-macros/subscribe > > -- > > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and > co-workers > know they can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > >>> > >>> > >>> > >>> -- > >>> P.VIJAY KUMAR > >>> > >>> -- > >>> > >>> > -- > >>> Some important links for excel users: > >>> 1. Follow us on TWITTER for tips tricks
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 '~' 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 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 >> >> >> A B >> 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 want is there,number of characters which you want from the >>> text) >>> Ex: If a Cell B2 Contains TIGER999 .Use the function = RIGHT(B2,3) to >>> get the required 999 as the answer. >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> 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 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 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 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 > > > > -- > When everything fails Patience will win > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and co-workers > know they can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe >>> >>> >>> >>> -- >>> P.VIJAY KUMAR >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 > > >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 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: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 >>> 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 >> > 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 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 > -- When everything fails Patience will win -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> >> >> -- >> P.VIJAY KUMAR >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > One Team One Dream One Goal > > Warm Regards, > Vikas Chauhan > E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, > 9911868518, > "We can't Spell S_ccess without U" > > Life is Very beautiful !!! > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´. > > -- > > -- > Some important links for excel users: > 1. Fol
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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: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 >> 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 >> 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 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 >>> >>> >>> >>> -- >>> When everything fails Patience will win >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > P.VIJAY KUMAR > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- One Team One Dream One Goal Warm Regards, Vikas Chauhan E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, 9911868518, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !!
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 > 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 > 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 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 >>> >> >> >> >> -- >> When everything fails Patience will win >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- When everything fails Patience will win -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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: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 > 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 > 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 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 >>> >> >> >> >> -- >> When everything fails Patience will win >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- P.VIJAY KUMAR -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Re: Extract Right Word in Line
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 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 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 >> > > > > -- > When everything fails Patience will win > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Extract Right Word in Line
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 and Regards, > Anand S > > > -- > When everything fails Patience will win > -- When everything fails Patience will win -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe