Dear Experts, Thank you very much to all …. I'm eager to learn many thing on Excel I need assists from all Experts . I want to build my career in this profession
Thanks Manjunath From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bé Tr?n Van Sent: 23 November 2012 09:07 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ FW: REmove duplicate entries Attachments 2012/11/23 Bé Trần Văn <betnmtdongna...@gmail.com<mailto:betnmtdongna...@gmail.com>> You check your data, a number of Cell contains a space in front data leeu. To remove white space you use the TRIM function to, at J3 you use the formula: = TRIM (C3) Complete copy of the column J, dragon to column E you choose Paste Special Value, and click the OK button. 2012/11/23 Manjunath Narayanappa <manjunath.narayana...@aon.co.uk<mailto:manjunath.narayana...@aon.co.uk>> Dear Sir/Madam, Thank you so much but in few entries there is a space so it doesn’t show as duplicate entry Regards Manjunath From: Orlando José Mézquita Fabián [mailto:orlando.mezqu...@gmail.com<mailto:orlando.mezqu...@gmail.com>] Sent: 23 November 2012 02:27 To: excel-macros@googlegroups.com<mailto:excel-macros@googlegroups.com> Cc: Manjunath Narayanappa Subject: Re: REmove duplicate entries Go to the Data Tab and on the 'Data Tools' group select remove duplicates. This will work for Excel 2007+ On Thursday, November 22, 2012 10:19:18 AM UTC-4, Manjunath Narayanappa wrote: Dear Team, In the above attached Spreadsheet, I have more than 3777 row in which Column C has duplicate entries Wherein im unable to remove duplicate entries due to space in it. Please teach me so it will be new learning for me Regards Manjunath ________________________________ PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. ________________________________ PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- 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-macros@googlegroups.com<mailto:excel-macros@googlegroups.com>. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com<mailto:excel-macros%2bunsubscr...@googlegroups.com>. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- 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-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. ________________________________ PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL For Aon’s standard conditions associated with this e-mail please visit http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp Aon UK Limited Registered Office: 8 Devonshire Square, London EC2M 4PL Registered in London No. 210725 . VAT Registration No. 480 8401 48 Aon UK Limited is authorised and regulated by the Financial Services Authority in respect of insurance mediation activities only. -- 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-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
