removes

Hi everyone, I have data in sheet"Raw Data2" and down column J I have dates, Id like to be able to have a macro that sorts the data in columns A:Z Newest date to oldest then removes any dates that are before 2018 please help if you can. Thanks Tony

Hi, How can I paste numbers with dash in between like the ones below and it calculates the total 37? In other words I want a formula that it removes the dash and calculate all the numbers together 2+2+4+2+2 etc.... 2-2 4-2 2-0 1-2 1-1...

Receiving data as: <tbody> XXXXabc(XXXX) XXXXabcd XXXXabcde(XXXXXX) </tbody> I need a formula that removes the first 4 characters and removes parenthesis(and data within) IF they appear at the end. I started with... =MID(A2,5,FIND("(",A2,1)-5) which behaves fine for cells with...

Hello, I can't manage to get a macro working. I'd like to create a macro that removes all columns that have duplicate headers. Please advise, Steve

Hey Everyone! I created a macro a few months ago that help us to make some reports easier to input. There are multiple lines in these responses that we don't need and the only way to find the ones we do need I used the following method. All of the cells that we needed started with a number, had...

I have a large spreadsheet of data that goes from Columns A to Columns AD and is about 2000 lines. The spreadsheet is created from some Access database (I am not familiar with the process). For some reason various cells end up with quotes at the beginning of the text in the cell (e.g. "USE...