data cleaning

When I get a report out of the system, “column a” should have all the names, instead it is first few rows name is in “column a”, then it is in “column b” then in “column c” and so on…. So I want to add a column before “column a” and in the “new column a” I want to get data from all the other...

I have a Range of Cells that I would like to transfer to PowerPoint using VBA Macro. The problem is that some of the cells are emty at times and I want to leave them out of the final range that is moved to PPT. I'm thinking that I have to select the largest possible range and then do some...

Hi Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to create a script that will clean data in the table using a specific way. <o:p></o:p> Here is the file with the original data and the results:<o:p></o:p>...

Hello, I am using Excel 2010. I need to remove spaces from a series of numbers but the spaces are in different places. So there are two spaces to remove in row 1, two in row 2, 1 in row three and so on. Is there a single formula that will do this or do I need to run a series of formula...