remove blank cells

  1. S

    TEXTJOIN using IF & "addtext" but remove if cell is blank.

    I am trying to TEXTJOIN to create links to my filepaths, whilest adding text that I need - but I don't want it to bring back anything when I have no vaule. Any help would be massivly appriciated. ABCDEFGHIJKLMNOPQRSTUV1File PathStyle...
  2. M

    Please Help With Shift Data Up Macro

    Hi everyone, Please help me with a little code that I have. I am hoping we can tweak it a little. I have a sheet that has columns grouped by 4 and separated by 2 blank columns. The data goes far to the right and is only 600 rows deep. The idea is to move all scattered data to the top leaving...
  3. O

    VBA for edit text and remove blank rows

    I m finding out VBA for merging text with a space from below cells which has blank at the next column , and then remove the row that has blanks, as shown below.:confused: First Form <colgroup><col span="2"><col><col><col><col><col></colgroup><tbody> 1 1.500WT - PIPE SSAWL API 5L BE 30...
  4. L

    Array formula to determine changes in price and time of changes

    Hey! I've been looking around for a while in the forums, but haven't been able to find a solution. I'm working on an array formula that is supposed to determine when a price of an item has changed and what the new price is based on an inventory log that contains several different items. I've...
  5. E

    Extract Non-Blank Cells in a row from a database using 2 criteria to find the row.

    I have a database which lists daily entries of production data. In my process, material is input as one code, processed, and broken down into several output codes by composition. Within each production run, there are several metrics such as input code, production time, input weight, output...
  6. J

    Extract non-blank data from a list

    Hi everyone. I am using the following array formula to compact a list by removing the open rows. =IFERROR(INDEX(HN4:HN5740, SMALL(IF((HN4:HN5740)="","", ROW(HN4:HN5740)-MIN(ROW(HN4:HN5740))+1), ROW(HN1))),"") It works brilliantly on a short list. However, my list is actually 7300 rows...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top