Code for Text to columns using spaces

Hello all,

Is there a VBA code to select from range A3 to used range of A columns to do Text to columns delimited with spaces?

I tried to do with record macro but I couldn't achieve it

what about the command texttocolumns? do you know how to use that?

it is found under the Data menu, then goto Data Tools and select Text to Columns.

do you need further help?

Thanks for the code Alan!! It works fine!!

@dmcgov

I'm looking for code to automate. Thanks for your reply