Formula for replacing specific characters


Hi everyone! I am struggling with the formula language for this.

So in Column 1 I have the file names with their file extensions.

In column 2 I'd like a list of the filenames WITHOUT the extensions (see the top row)

Is there a way to write a formula to replace the LAST 3 characters with nothing?

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!