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 John23son - 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 Wednesday, October 30, 2013 4:36:42 AM UTC+5:30, Diamond Dave wrote: > > I have a situation where I down load data and delineate results leaving > a name with blanks behind the number making a Vlookup difficult. > > > > ASIAN HONDA MOTOR CO.,LTD. > > > > The name above is an example. Is there a formula I can use to remove any > blanks behind the last character? > > > > Your help as always is appreciated. > > > > Regards > > > > Dave > > > > *Visit* > > *http://www.excelvbamacros.com/ <http://www.excelvbamacros.com/>* > > > > > > P Before printing, think about the environment. > > > > > > -- > 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 post to this group, send email to excel...@googlegroups.com<javascript:> > . > To unsubscribe from this group, send email to > excel-macro...@googlegroups.com <javascript:>. > Visit this group at http://groups.google.com/group/excel-macros?hl=en. > > > -- 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.
