The raw file has characters that need to be removed...
Sometimes when you run an extract, the file contains data characters that you don't want in your file list.
These could be commas, dashes, stars or any weird character that is added with source files. Want to strip this out quickly? Here is a formula that can help.
Note - there is an easier way to do this using "text to columns" - but lets keep it interesting and use just formula.
Abe Dahbache has been working with EXCEL for over 15 years. He is a Microsoft Office User Specialist and has been developing solutions in Excel for some of the worlds largest companies.