spilt words

Originally Posted by delboy2405

That does what i want except the data gets updated anywhere between 1min and 20 mins so would need to do it manually or set up macro where is i don't want a macro if can get away with it

Here's an little vba code that you could use
Maybe even kick it in with a worksheet change event

Sub Macro1()
    Application.DisplayAlerts = False
    Columns("A:A").TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
                                 TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _
                                 Semicolon:=False, Comma:=False, Space:=True, Other:=True, OtherChar:= _
                                 "-", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), _
                                                       Array(6, 1)), TrailingMinusNumbers:=True
    Application.DisplayAlerts = True
End Sub