Formula Require

Question

Dear All,

In one column I have data in below mention format.

I want formula to extract only numerical and alphabetic part in two different columns. That is (78601065) in one column and (Record Digitized) in other column

Please help

Thanks in advance

78601065_Record Digitized

binu_acs · Answer

@Mohini79 Some other methods

Parse_250423.yxmd

DataNath · Answer

Hi @Mohini79, if all of your field is consistently in this format then you can just use a Text to Columns tool. Set your delimiter to ‘_’ and set the number of columns to split to to 2.