Separating text and numbers into separate columns

[kebab]

How do I take the combination of text and numbers in Column A and separate them into individual columns B thru F?


Column A "New England 6.73 Kansas City 0.713 247"

Column B "New England"

Column C "6.73"

Column D "Kansas City"

Column E "0.713"

Column F "247"

[MrShorty]

First thought is to use the text to columns command: https://support.office.com/en-us/art...A-7A3E9C363ED7

[kebab]

Thank you that did the trick.