Hi All,
I have a requirement, where in I need to split the text which has some delimiter of " - " and I need one particular split of the given text.
example - "Alpha - Beta - Gamma - Delta" on this I need only "Beta" in a separate column. I want to us formula then using the text to column option to avoid performance issues considering the volume of data. Please help
Thanks
Solved! Go to Solution.
Hi @Naga
Try this in a Regex tool
The Regex string is .*?-(.*?)-.* which returns every thing between the first and second hyphens
Dan