www.quickdatacleansing.com is an online data cleansing solution. The need for data cleansing is made clear when considering how easily errors can be made. In a database of names, addresses or contact numbers, for example,
- Name might be entered as Bobby John¼23son. - Address may be 143$2!^&a,/ random stree@@$t - Contact nos. may contain alphabets or special characters like 123ab@#456. Such variations are most likely an error. If you are dealing with such type of error then www.quickdatacleansing.com is the right website to cleanse your data and fix it online, instantly within seconds, and under just nominal cost. May be most of your basic issues in data cleansing gets solved. Thanks. Ashish Bhatnagar On Monday, June 4, 2012 8:44:34 PM UTC+5:30, SG wrote: > > 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 advance. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
