Alter 09)

09) Convert Asterisks to Dashes 123456*1 becomes 123456-1

When asterisks appear in data on which you want to VLOOKUP or MATCH Excel treats them as wild cards.  This causes unexpected results in your returned values.

Use this to convert the asterisks to dashes and then look for the values with dashes.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc