remove

Hi - I have a spreadsheet with data in columns A:E. In column B is a date. I would like to remove all rows with a date more than 7days older the today(). Ideally i'd like to have a popup that asks remove dates prior to? thanks!

Hi, how can I remove lines within each cell (multiple lines with line breaks) that are not starting with a numeric character? <tbody> 223213 - this line needs to stay chair - this line needs to be removed 9 - this line needs to stay needs to be removed </tbody> Thanks and best, Jack

I need the below to read White, Blue, Red & Silver. I have used the =SUBSTITUTE(B4," &", ",",1) to remove the first one, but I can't figure out how to remove the second &. Please help. TIA <colgroup><col width="64"><col width="203"></colgroup><tbody> ADJ4 White & Blue & Red &...

Hi, New here and searched all over the internet and could not find an answer. I have a CSV file with 499,846 rows in it. Each row has a field or spaces separated by commas. The commas are used as delimiters so when I open this CSV file in Excel, those commas will be used as rows. Example...

Hello everyone, I have a macro that creates a new file almost similar to the one it runs on by Saving it As, copy/pasting as values every sheet and removing the old ones. It goes like this : Sub Export_EDF() Dim Feuille As Worksheet Dim FeuilleRef As Worksheet Dim Sheet As Object...

Hello, When I try and remove a calculated item that somehow (user error) got added to my sheet, the following error pops up: "The pivot table field name is not valid. To create a pivottable report, you must use data that is organized as a list with labeled columns." Help? Thanks! -Ben

Hello Guys, I saw this post here: https://www.mrexcel.com/forum/excel-questions/712373-how-remove-consecutive-number-string-only-column.html On how to remove consecutive numbers in a row, when I apply its suggestions I do not get any results. I am new to VBN, can anyone help me with a...

Hi all, need fast help on this as I'm under a timescale. I have a list of ads due to be placed in a paper and under the "Pickups" for coach travel there is meant to be a list of coach-only pickups, but air and rail have slipped in. As an example, please see the below: Bury St Edmunds...

Please help with the following Macro: At the stroke of a key eg. (Cntl R) <colgroup><col></colgroup><tbody> Select entire column A Sort Column A Remove duplicates in column A select entire column B Sort Column B Remove duplicates in column B Cut all data from B1 to last non empty...

I have and column that reads this "8.50 (13.0)". I would like to strip out the data into 2 columns and remove the parenthesis from the second one.

Hey, I'm looking to remove the time stamp from a cell, ex. 07/14/2019 8:23:27 AM BLACK, 07/10/2019 9:23:57 PM DIRECT, to 07/14/2019 BLACK, 07/10/2019 DIRECT. thank you for any assistance.

Hi :) So, I have one worksheet with columns, which contain numeric values. They are different in size (e.g. column A has 560 cells with values, column B 1300 cells etc...). I would like to delete last cell that still has value in each column. Any ideas? Thanks in advance, cheers

Hi Could anybody post a VBA routine to remove LEADING and TRAILING spaces from a Column of Text in Excel please. COL A will do for example purposes. Cant find exactly what I'm looking for on Google. Thanks

I have a large number of RTF documents that I am opening using Access. I would like to reformat the document and then copy them into a control. I am able to open the documents, and go though all the paragraphs in the document (using the paragraphs object). I found that my macro's are missing...

Hi, I'm looking for a way to remove time from a text cell so it just shows the other contents. EX: 07/02/2019 9:00:30 AM CREATED to 07/02/2019 Created Thank you for the help both in the past and now.

I have a sheet with formulas in it and I need to remove them which isn't a problem except one of the cells is creating a problem. I cannot adjust the source data or I would fix it there first. Each cell in the first 3 columns is in a formula format similar to ="xxxx-xx-xxxx" and the formulas are...

Hi, In order to automate a site and get around using the date picker ive found I can remove the 'read only' part of the input on the site which allows me to input the date, however i cant seem to automate this. Im trying to change : <input id="fromDatePicker" placeholder=""...

<tbody> First Name Last Name Email New FN New LN Laura Hale, PhD laurahale@gmail.com Prof Marcus Cvija cvijam@yahoo.com Ms Diane Stuart diane88@gmail.com Rey Torres rey.torres@yahoo.com Sam Harris, MBA sharris@gmail.com </tbody> Hi All, I would like to ask for help. I need...

Hello,</SPAN></SPAN> I need to remove empty rows from column C and rearrange Num column B </SPAN></SPAN> Original Data</SPAN></SPAN>...

I have various tables with date fields and have recently set all of them to not show the date picker; but the date picker still shows in select queries using those tables (old queries and new queries). Is there a way I can remove it from the queries? The query property sheet doesn't seem to have...