u/scrappydoofan123

We were unable to get into our AirBNB last night when we arrived and had to book a hotel. Since we still have three days left in the city, I asked our host if she could refund us for one night, then we’ll stay for the remaining nights.

She mentioned that she had refunded us for one night and the cleaning fee, totaling around $160, but I haven’t seen any official notification from AirBNB about this. Will I get a message/email confirming this refund? Or will it just hit my account in a few days?

At the office, one of the tasks I am HONORED to have on my plate is to clean up event attendance/check-in data for student organization events. I'm looking for a formula to add to conditional formatting that can check the following criteria:

• Cell value (stored as text) is nine characters long
• Each cell should begin with an 'M', followed by 8 number digits
  • EX: M01234567

Any ideas on this?