Need help for notepad and excel

Please help me to read “*.txt” file from desktop and split each line in such a way that all alphabets should come in first column and numbers in second column. Paste these 2 columns in excel sheet

1 Like

@Ajith_Kumar Can you send the Txt File :sweat_smile: or show a screenshot of it

1 Like

Hi @Ajith_Kumar,

Can u provide your sample text file and expected output…!


It can be any random value…alpha numeric value

@Ajith_Kumar It would be more helpful if you provideus a sample, or else we would blindly make a solution which wouldn’t satisfy all the requirements :sweat_smile: