Hello,

I have a huge spreadsheet that I want to clean but the idea is simple.

I want to split a row into two at the location of a substring.

An example would be:

A1: Psychiatric ward building map. Notes: this item needs attention.

I want the final result to be:

A1: Psychiatric ward building map.
A2: Notes: this item needs attention.


Sometimes the punctuation before "Notes:" is something other than a period or comma. So I think something like a search function that locates the substring "Notes:" can be used as the splitter?

Any thoughts? I'm thinking using VBA because there is a total of 10k records, but I'm new and i'm looking for some guidance

Thanks very much