bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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
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