Help with Text string

[seftonbarn]

I have a column of data that consists of an 8 digit alpha/numeric code followed by 2 spaces followed by a description. For example:
"ABCD123A Text text text"

I would like to extract the code (removing the 2 spaces at the end) into its own column leaving just the description in its own column.

So "ABCD123A Text text text" becomes "ABCD123A" in one column and "Text text text" in the next column.

Any help or tips would be very much appreciated.

[zbor]

Here, try this:

[Andrew-R]

If your data is in column A, starting at row 2 then in B2 put:

=LEFT(A2,8)

And in C2 put:

=MID(A2,11,255)

Then copy down.

[Kyle123]

Or do find and replace for two spaces, replace it with something like |

Then do text to columns on |

[Marcol]

@ Kyle
If you want to use Text to Colums, why not just use the "Fixed Width" option with a column break after the 8th character and another before the text?
You can choose to skip the blank column in between.

[Kyle123]

Yep, that'd work, just don't like fiddling around with break lines, I always add them when I'm double clicking and it annoys me

[martindwilson]

dont get click happy,use mouse dicipline! lol