String into an array

[sekrah]

Looking for something that will look at a range. This range will contain 5 seperate words. I need the first two words and the last two words put into an array.

Example, say I have this string in cell A1:

ABC 123 TO XYZ 789

How do I split that into an array of "ABC 123" and "XYZ 789".

Please Login or Register  to view this content.

Any help is greatly appreciated.

Thanks

[sekrah]

Nevermind.. i'm such a dope.. solved it myself

Please Login or Register  to view this content.

pretty much gives me what I want. Unless there are better ways to do this.

[Leith Ross]

Hello sekrah,

Here is one way...

Please Login or Register  to view this content.

[shg]

Another way:

Please Login or Register  to view this content.

Select B1:C1, paste

=sekrah(A1)

... into the formula bar and confirm with Ctrl+Shift+Enter

Please Login or Register  to view this content.