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.

In the last issue, we introduced how to use the TIME function to display the time in 15-minute increments, 30-minute increments, etc. (TIME function) Excel pointed out that it would be easier to use the CEILING and FLOOR functions...