$$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

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

$$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 manojsnegi.uttranc...@gmail.com 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.

$$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

$$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 some

$$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 dcolarde...@free.fr wrote: Hi,

$$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 manojsnegi.uttranc...@gmail.com 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.

$$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 dcolarde...@free.fr wrote: Hi, Select the column, Ctrl+H,