Hi All
I have the following data the in cells A1 and A2
123456 - Summer 2020 - Norwich
345667 Holiday - 2019 Liverpool
How can I via VBA delete all cell data until it gets to the 1st Alpha Character so I would now get
Summer 2020 - Norwich
Holiday - 2019 Liverpool
So effectively the code would look it each cell and when it gets to first alpha Char it would split it this point
Any help would be appreciated
Zahed