Re: $$Excel-Macros$$ Text Cleaning

2012-06-04 Thread sonal
e there > > > > Use Function Worksheet Like : > > = RemoveSpecialCharacters(YourString) > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > exc

Re: $$Excel-Macros$$ Text Cleaning

2012-06-04 Thread sonal gupta
1) > End If > Next i > cell.Value = text1 > Next > Application.DisplayAlerts = True > Application.Calculation = xlCalculationAutomatic > End Sub > > > > On Mon, Jun 4, 2012 at 8:44 PM, sonal gupta wrote: > >> Hi, >> >> This is my first post in this group.

Re: $$Excel-Macros$$ Text Cleaning

2012-06-04 Thread sonal gupta
ShN = ShN & Mid(Shname, i, 1) > > End If > > Next > > RemoveSpecialCharacters = ShN > > End Function > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtal

$$Excel-Macros$$ Text Cleaning

2012-06-04 Thread sonal gupta
Hi, This is my first post in this group.I have learnt many things from this group.I'm finding difficulty in cleaning the range in which each cell has string like " rahul;6e3-".I need a macro which will clean the special characters,spaces & numbers & leave the alphabets only. Thanks in advanc

$$Excel-Macros$$ Fwd: Name Matching In Excel

2009-09-22 Thread Sonal Gadgil
Hi All. Please help me in this Thanks & Regards Sonal Gadgil -- Forwarded message -- From: Sonal Gadgil Date: Mon, Sep 21, 2009 at 9:46 PM Subject: Name Matching In Excel To: excel-macros@googlegroups.com Hi... I am new in this group. I am facing one proble w

$$Excel-Macros$$ Name Matching In Excel

2009-09-21 Thread Sonal Gadgil
Hi... I am new in this group. I am facing one proble while working in the excel. I am having two excel files where i have to map the customer based on customer name by matching customer name manually. Now, in case there is any macro available which help me to search & map names this will be gre