How to split text and Number in Excel Cell

Hi I wanted to get only the number from my excel Cell

image
I want to separate the “181” and “Days”

Any help?
Thank you in advance

@Vincent_Nuestro - if you always have spaces after the numbers then you can use split method, if not you can go with Regex …

image

1 Like

Hi sir, can you share your workflow? I haven’t tried to use RegEx before

I have already showed how to code the Regex in the screenshot…Please refer the below link for complete Regex guide which will help you…

Note: Assign → Row(“Your Columname”) = system.text.RegularExpressions.Regex.Match(Row(“Your Columname”).tostring,"\d+").Value

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.