|
Featured Tutorial
Featured Macro
Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble
Extract data with MID and use VLOOKUP to retrieve a date. See how to lookup the middle part of a text string and return a value when the substring is a number shown as text. See how to convert numbers as text to numbers inside a formula.