Dear Tariq, I have attached Excel sheet in trailing mail.
-- > Thanks & regards, > Noorain Ansari > http://noorain-ansari.blogspot.com/ On Fri, Aug 19, 2011 at 11:14 AM, Tariq Aziz <tariqkh...@gmail.com> wrote: > Dear Noorine > > The file is not attached. > > Tariq > > On 18 August 2011 17:36, NOORAIN ANSARI <noorain.ans...@gmail.com> wrote: > > > > Always welcome dear > > On Thu, Aug 18, 2011 at 4:36 PM, karunanithi ramaswamy < > era_...@yahoo.com> > > wrote: > >> > >> Dear NOORAIN ANSARI, > >> THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE. > >> Karunanithi R > >> ________________________________ > >> From: NOORAIN ANSARI <noorain.ans...@gmail.com> > >> To: excel-macros@googlegroups.com > >> Sent: Thursday, August 18, 2011 2:43 PM > >> Subject: Re: $$Excel-Macros$$ USAGE OF "RIGHT" & "REPLACE" FUNCTIONS IN > >> VBA-REG > >> > >> Dear karunanithi, > >> > >> Please try below VBA Function..and see attached sheet.. > >> > >> Function use_cbt(s As Range) > >> use_cbt = Application.WorksheetFunction.Substitute(s, "CB", "CBT") > >> End Function > >> > >> > >> On Thu, Aug 18, 2011 at 2:30 PM, karunanithi ramaswamy < > era_...@yahoo.com> > >> wrote: > >> > >> Hi, > >> I am using some vba to filter some data related with station code, > >> such as AVN,CBAVN,CBEAVN,CBTAVN > >> all the four meas the same station, but used in different software. > Here, > >> my job is I have to collect the data in > >> any one of the formate say CBAVN in any column and then replace them to > >> CBTAVN and proceed. > >> I use macro and compile my data(file attached).There are 300 station > >> codes .What I want is: > >> 1.Can i use 'Replace' function in vba code to convert 'CBAVN' IN B1 to > >> 'CBTAVN' in A1 column. > >> 2.Can i use 'Right'function in vba code direectly,but it shows 'Object > >> error' > >> Thank you if any one helps > >> Karunanithi R > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> 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 > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > >> > >> > >> -- > >> Thanks & regards, > >> Noorain Ansari > >> http://noorain-ansari.blogspot.com/ > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> 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 > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> 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 > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > > > > > > > >> > > -- > > > ---------------------------------------------------------------------------------- > > 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 > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > -- > > ---------------------------------------------------------------------------------- > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Thanks & regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/> -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
