Hello all,

I have found all kinds of find & replace samples, but nothing to delete text after a certain character count...

My sheet contains a column R with date stamps:

2020-05-04T18:31:53.280Z
2020-05-01T23:10:06.774Z
2020-04-17T23:02:57.912Z

I'm looking for a macro that removes everything after and including the letter T (it's always the 11th character)

2020-05-04
2020-05-01
2020-04-17

Thank you in advance for your help!