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.

Absolute and relative references are explained below. Relative reference: If you want to display the same contents in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3. If you want to display the same content in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3