Data to the left of the first space

[bobgrand]

Hello all,
I have a column of product codes. The beginning part of the code is what we call the prefix. This can be anywhere from 2 to 6 characters in length followed by a space. I need to take the prefix part of the product code and put them in a separate column. I tried a couple different formulas but was not getting the right result.

Any help would be greatly appreciated

Have a great day
Bob

 

[bobgrand]

Rory,

My bad. I should have just tried it. I had it in my head that you were suggesting to add spaces manually to each item that didn't have a space. I don't even know why I was thinking that. But thank you very much for your suggestion.

Bob

 

[RoryA]

Bob,

No problem - glad it worked!