Hello,
I would like to extract the data from a text string at each space using formula rather than text-to-column tool. the text will have 4 interior spaces and a mixture of text and numbers.
For example, in cell A10 will be: abcdef 04/13/2018 140.50 ghiab hgvjw
I would like B10 to contain...