Hi,
I'm trying to use RegEx to separate the following B185661B Chips Ahoy Valley Tees. I would like it to be one column has the B185661B and the other column has the Chips Ahoy Valley Tees. Please let me know if this is possible. The excel file is attached.
Solved! Go to Solution.
@dholder15 is there a reason this needs to be done with RegEx i.e. is there a certain pattern you're looking for? From your example it looks like you may just be splitting a product name from a code that's the first word? If so, you can just use a simple solution like so:
Splitting the field in 2 based on the first space (\s delimiter).
Hi, @dholder15
Here's another way for your use case - to expand your options beyond Regex😎
I hope you find it helpful - Cheers!
Thank you so much! That helped out tremendously
You're most welcome @dholder15!