RE: $$Excel-Macros$$ FW: REmove duplicate entries

2012-11-23 Thread Manjunath Narayanappa
t: 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 mailto:betnmtdongna...@gmail.com>> You check your data, a number of Cell contains a space in front data leeu. To remove white space you u

Re: $$Excel-Macros$$ FW: REmove duplicate entries

2012-11-23 Thread Bé Trần Văn
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 Na

$$Excel-Macros$$ FW: REmove duplicate entries

2012-11-22 Thread Manjunath Narayanappa
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] Sent: 23 November 2012 02:27 To: excel-macros@googlegroups.com Cc: Manjunath Narayanappa Subject: