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.

Scenario
So you have a list of names in one column of a workbook - and you want to work out if they are attending a special event that is coming up.

Column A - has the list of names we are looking at (This is our Master List)

Column B - needs to be filled out with either a "Yes" or a "No" using our look-up from another list.

Problem:
The information we want is actually on another Excel sheet - lets take a look at what this 'Other' sheet looks like...