$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

hi, try this macro Sub RemoveChar() Dim StrAdd As String StrAdd = Range("A5000").End(xlUp).Address Range("A1").Select While ActiveCell.Address <> StrAdd If InStr(1, ActiveCell.Value, "*") > 0 Then ActiveCell.Value = Right(ActiveCell.Value, Len (ActiveCell.Value) - 1) End If

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Hey Daniel this was fantastic... thanks for the knowledge Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote: > Hi, > > Select the column, Ctrl+H, what : “~*” (with

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Very Good Daniel/Norman...You have got excellent knowledge of Excel.. Keep it up !! On Jul 8, 8:26 pm, Manoj S Negi wrote: > Hi All, > > Thanks a lot for you allmy query has been resolved by your nice > solutions. > Really very nice tricks I got from you all. > > Cheers... > > *Unfe

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Hi All, Thanks a lot for you allmy query has been resolved by your nice solutions. Really very nice tricks I got from you all. Cheers... *Unfeigned Regards Manoj S Negi "Miles & miles to go before I sleep"* On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote: > Hi, > > Select the co

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Manoj, In the find and replace box precede the asterisk with a tilde. Example: ~* Norman On Wed, Jul 8, 2009 at 6:06 AM, Manoj S Negi < manojsnegi.uttranc...@gmail.com> wrote: > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is s

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Hi, Select the column, Ctrl+H, what : “~*” (without the quotes), replace all. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Manoj S Negi Envoyé : mercredi 8 juillet 2009 12:07 À : excel-macros@googlegroups.com Objet : [Norton AntiS

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

hi manoj i am new in useing excel On 7/8/09, Manoj S Negi wrote: > > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and

$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row

Manoj, Attached is the file with macro. You just need to select the respective cell and run the macro. Thanks Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 8, 2009 at 3:36 PM, Manoj S Negi < manojsneg