If string contains a hyphen before the comma, change the hyphen into another character

[erinylai]

Hi all - I am wondering what workflow to build to achieve the above desired output. Essentially I am trying to change the hyphen from the section before the comma since I want to eventually text to column the whole cell without messing up elements such as E18-1 and B718-2. 

Would appreciate any pointers! Thank you. 

[binuacs]

@erinylai Two ways of doing this (Regex and String functions)

[erinylai]

Hi binuacs, thanks so much for your response! I tried incorporating into my workflow and I am encountering a few challenges since the full dataset has ~70k rows. How would you suggest that I modify the workflow to accommodate to the larger datasets? 

Thank you!! 

[Luke_C · Accepted solution]

Hi @erinylai 

Not sure if your sample data is representative, but if it is you can try the replace first function: 

[binuacs]

@Luke_C You made it so simple, I forgot about the ReplaceFirst function and made the formula too complicated 😀

[binuacs]

@erinylai Can you upload some dummy data if possible?

[erinylai]

Hi binuacs, you helped me with the bigger question under another post so will close this out here. Thanks again!