Option Explicit
Private Sub Worksheet_Change(ByVal c As Range)
If c.Address = "$A$1" Then
If c.Value = "" Then
Range(Range("b4"), Range("b4").End(xlToRight)) = ""
Exit Sub
Else
Application.DisplayAlerts = 0
Range(Range("b4"), Range("b4").End(xlToRight)) = ""
Range("a1").TextToColumns Destination:=Range("B4"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1)), TrailingMinusNumbers:=True
Application.DisplayAlerts = -1
End If
End If
End Sub