Hello,
There is a column that has a mix of numbers and "-" and text. I'd like to extract the text at the end of the string into its own column. What is the best way to do that? Attached is the file with the data. Thanks
Solved! Go to Solution.
How does this look @lipster26? Workbook attached:
(?:[0-9-]+)-([a-z\s'-]+)
EDIT: Simplified the RegEx
(?:[0-9-]+)-([\D]+)
That works perfect. Thanks!