cleaning data

Hi This is the original file for which I seek your kind consideration. This is the desired output file I need your kind gesture and help to get the output file with the following parameters Delete Column A ,C, D ,J,K,M,O,and P to AH completely. After the given columns are deleted I request...

Hello all, I need to perform a find and replace on multiple values that I'm sure can be coded in excel. I have a list of address that have certain words that need to be replaced with a '~' symbol and some terms replaced with their abbreviation. For instance: Addr addr_2 123...

Hi, I have been trying to create a calculator which looks at returns from a stock if you average in over time (average in is when you put $2000 into a stock every month or two months or so). Using data from yahoo finance such as...

Hello All, I have a column of seat (arena) data. The data contains section numbers and rows. I want to extract the section numbers into 1 column and the row (letters) into another column. Here's an example of my data set: <colgroup><col></colgroup><tbody> 104 BB 103 & 105 BB 104 CC 103...

Hi, so I have large workbooks that contain many sheets each with many rows of data. lots of these rows are either entirely #N/As or entirely zero, and I would like to remove these. I have some code that sort of does it: Dim ws As Worksheet Application.ScreenUpdating = False...

Hi, I'm copying data between two excel: ... For i=2 to rows_x TEMP_city = ws.Range("B" + CStr(i)).Value 'this value can contains space wsSC.Range("A" & AT_rows).Value = TEMP_city ... next i ... How can I during this process use Trim or Clean function, to delete "space" etc.??

Hello. I have a worksheet that is linked from A1 to J400 to corresponding cells of another worksheet. The originating worksheet has formulas that produce blanks in several rows throughout the data. I would like to know how I can have the linked worksheet ignore the empty rows and stack the data...