Data cleaning

**platesigns** · 07-13-2014, 12:27 PM

Hi

in the attached data I have some rows with numbers starting with 27. For such rows I want to delete the number 27 in that row

some rows have more than 9 digits - if such a row exists, we must keep the first 9 digits in the same row and move the balance to an inserted row below

some rows have no entries or just a 0 - these rows must be deleted - also if there is text in a row it must be deleted

all duplicate rows must be deleted

can anyone help with this please

**mrice** · 07-13-2014, 12:50 PM

Try this

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.