[panda.]

i have a ":" separated text file that i have to convert into excel sheet
how can i do that??
my file in in this format
1.0:aaaaa
2.0:bbbbb
5.2:cccc

i want it in an excel sheet
1.0 aaaaaa
2.0 bbbbbb

can someone please help

[requinix]

Copy and paste into Excel, select all, use Text to Columns to split on the colon.

If you need an automatic method, replace the colons with tabs and give the file a .tsv ("tab-separated values") extension. Excel can open those too.