I am doing a project where I am entering all the file names of a folder in an excel sheet, but in the local folder, there are some files like (1.jpg, 1,pdf, 1.rar) while entering the filename into excel, I only want to enter one 1, not three times. how can I do that? filename.xaml (9.0 KB)
there is an another small problem. some filename value is decimal number so excel is cutting down the last digits after last 4 digit.
but i need the exact value.