Formula Require

[Mohini79]

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

[DataNath]

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.

[binuacs]

@Mohini79 Some other methods