RegEx for Splitting Data

[dholder15]

How would I split a column with an example like this: B000984 muse love rhyno yogo

I ask because I can't do text to columns since there isn't a delimeter to utilize. I've done regex to get the A000984 in a separate column, but I can't get the "muse love rhyno llc computation" part. Let me know thoughts/feedback. Thanks!

B000984 Muse Love Rhyno Yogo

B102562 CCG Metro Tough

[ShankerV · Accepted solution]

Hi @dholder15 

Please find the expected output

[dholder15]

Hi @ShankerV ,

Thank you so much! It worked out perfectly!

[binuacs]

@dholder15 One way of doing this