excel 2021

  1. S

    VBA: Split text in cells to multiple rows

    Hi, I am looking for a VBA to split the text into cells into rows. Input: A12Company, id*; ¤¤¤Communications Media, http://www.Communications.com/Media.3Company, id*1; ¤¤¤enter fr gic an, ght cer tit, reo th and ce ersit, and, p0 99, 9A. c e:9k@o.u.+=+enter fr gic an, ght cer tit, reo th and...
  2. S

    VBA: Match with ID in sheet 1 and delete rows with matching ID in other sheets

    VBA: Match with ID in sheet 1 and delete rows with matching ID in other sheets Example SheetX id customer name item error code aaa_1@#$Gl cd.1@#$Gl2 efg1@#3$Gl 1@#5$Gl Sheet A input id customer name error code1 error code2 1@#5$Gl any name2 any...
  3. J

    LAMBDA Function to create a dynamic array from data whose rows grow (or shrink) - _FredRange

    A while back I discovered an Excel Add-In called FRED Data provided by the Federal Reserve Bank of St. Louis. What it does is allow you to retrieve data from various Federal agencies such as the Consumer Price Index from the U.S. Bureau of Labor Statistics. The problem is that the data is...
  4. H

    Return Date above the Certain "TEXT" from the "NAME" in (Excel2021)

    Hello, Good Day to you, I've to Find the Public Holiday taken with different year for certain Name In Sheet "Public Holiday" If I put the year next to PH 1, Example "PH 1 (2021)". it can return the value but I need match with the 'NAME" I want to keep the PH 1 Separately from the year...
  5. C

    VBA find and replace entire cell contents

    Hello, I am running Excel 2021 and I have a two sheets, here's Sheet1, it contains values of find (col A) and replace (col B), there might be 1k of rows in there: AB1Abigail<a href="https://example.com/abigail.html"><img src="https://example.com/abigail.jpg"> Abigail</a>2Sophia<a...

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