Would like to delete some useless system text in a column, but not all the text in the cell. Each cell will have date entries. Would like to delete the useless text and the date preceding it. Each date is on a separate line within the cell.
So far, I have the delete text part down, but it doesn't include the date.
Example:
jan 1, 2023 text 1
dec 31, 2022 useless text 123
dec 11, 2022 text 3
dec 3, 2022 useless text 456
So far, I have the delete text part down, but it doesn't include the date.
Example:
jan 1, 2023 text 1
dec 31, 2022 useless text 123
dec 11, 2022 text 3
dec 3, 2022 useless text 456