Struggling to extract text after a specific character in Excel when data lengths vary? This article explains how to combine the RIGHT and FIND functions to solve the problem—taught by an experienced Excel formula expert.

The VLOOKUP function is a very useful function for handling data, but many of you may have experienced that once you get stuck in the error swamp of #N/A or #REF! In this article, we will discuss how to use the VLOOKUP function to get rid of the #N/A and #REF!