Hi All,

In Column A, I have a text data. Between words there is one space. I would like to split the column to multiple columns whenever there is more than one space between words (such that delimiter is 2 or more spcaes)

I thought that splitting the text when meeting more than one blank space could be a good idea.

Can Anyone assist with VBA Code please?

Many thanks,