1

I currently have payments going into a Google Sheet in the current format:

Date                      | Company  |   Location       |  Category         | Paid
                          |          |                  |                   |
March 10, 2020 at 12:00PM |xxxx      |55 Street, USA    |Shopping           |$40.65

Is it possible to take the date and simplify it down to only the month and year (like "March 2020), I'm using this data in another sheet and simplifying the data by month and category.

Something like this:

Date       |  Category         | Paid
           |                   |
March 2020 |Shopping           |$40.65
0

You can try a regular expression with Regexreplace()

=REGEXREPLACE(A1,",|at.*",)

enter image description here

  • That's just what I'm looking for, thank you! – Primidium Apr 10 '20 at 4:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.