extract date

  1. larinda4

    Extract Date from Text

    Good morning, I have this text, (and it changes but it'll always be annual. Feb-Jan, July-June, etc.) and I need to pull the starting date from the cell. For the Period: May 01, 2021 to January 30, 2022 I currently have this formula but it'll only work for some of the months, not all. For...
  2. H

    Extract nonzero data

    Hi, I hope you can help me with this. I have a set of data <tbody> Code Cost A 10 B 0 C 0 D 15 E 13 </tbody> How can I extract the nonzero data in the following shape: <tbody> A 10 D 15 E 13 </tbody> Thank you!
  3. A

    Need formula to convert a timestamp to date

    Okay, so the data I'm looking at exports in this format "10/1/2013 9:25:00 AM", which I need to convert to "10/1/13", or something similar, stripping out the time element. The obvious answer, format cells/date is not helpful, as I need to manipulate the exported data in a pivot table, which...
  4. L

    Extract date from text (long date format)

    Hello, I was wondering if it is possible to extract the date from a long text field. I have two problems, 1- Inconsistency across fields, 2- Long date format (day month year). I have come across a solution by Rick Rothstein; it works perfectly but my problem is with the long date. Here is...

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