Formuladrill

Level 4: Text and dates Exercise 71 of 118

File extension

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Return the file extension: the text after the last dot in each file name. Some names contain more than one dot. Fill B2 and B3.

What this exercise teaches

TEXTAFTER and TEXTBEFORE split text on a delimiter without FIND and MID, and a negative instance number counts from the right. FIND alone would stop at the first dot and return final.xlsx.

A hint if you get stuck

TEXTAFTER(text, delimiter, instance) returns what follows the delimiter. An instance of -1 counts from the end, so it finds the last dot.

Functions used: TEXTAFTER

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Text and dates