How to make a sentence an array of words

[landish]

I have a sentence in a cell i.e. "The weather is nice today". I'd like to make it an array of words like this: {"The","weather", "is", "nice", "today"}. Any idea or help on this problem will be appreciated. Thank you!

 

[MickG]

Perhaps:-

Dim wds As Variant
'Place "A1" into array Wds
wds = Split(Range("a1"), " ")
'Enter array on Row 2
Range("A2").Resize(, UBound(wds) + 1) = wds
'Join Array and place in "A3"
Range("A3") = Join(wds, " ")
'Or perhaps this
Range("A4") = """" & Replace(Range("A1"), " ", """,""") & """"

 

[landish]

Thank you MickG! Is there any way to complete this by formula functions? It would be great to solve the problem this way. Thanks

Perhaps:-

Dim wds As Variant
'Place "A1" into array Wds
wds = Split(Range("a1"), " ")
'Enter array on Row 2
Range("A2").Resize(, UBound(wds) + 1) = wds
'Join Array and place in "A3"
Range("A3") = Join(wds, " ")
'Or perhaps this
Range("A4") = """" & Replace(Range("A1"), " ", """,""") & """"

 

[MickG]

Try:-

=""""&SUBSTITUTE(A1," ",""",""")&""""

 

[landish]

Thanks MickG for sharing your ideas on this problem.

Try:-

=""""&SUBSTITUTE(A1," ",""",""")&""""