Splitting Text Into Separate Columns

[Mvaldesi]

Hello, Gurus!

I have some data (attached) that lists vessel names and their voyage numbers in a single column. What I'd like to do is separate the voyage numbers into a separate column. I tried to figure out how to do it using text-to-columns, but as the vessel names can vary in length, fixed width doesn't work, and I can't use delimited either as "spaces" are the only delimiter and can occur within the vessel name; I need the names to remain intact. I feel like I'm over thinking this; this seems like a pretty basic function.

Little help, anyone?

Thanks in advance!

[Fluff13]

How about

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

[Mvaldesi]

How about

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Yup! That does it!! Thank you!!

[Fluff13]

You're welcome & thanks for the feedback.

[Czeslaw]

Power Query

Please Login or Register  to view this content.

[zaska]

A single Cell formula, just in case exploring more ideas

Please Login or Register  to view this content.