Good day, I need to split text to columns where the itaisized words are taken to the next column.
Current Column A = Pied Avocet Recurvirostra avosetta
When split,
"New" Column A = Pied Avocet
and
Column B = Recurvirostra avosetta
Once done, I can use TRIM to get rid of superfluous spaces.
Willl the above be possible with some VBA clever code please?