Formula for replacing specific characters

Cassie Hart

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!

Paul Newcome

Try this...

=LEFT([File Name]@row, LEN([File Name]@row) - 3)

Paul Newcome

Try this...

=LEFT([File Name]@row, LEN([File Name]@row) - 3)

Cassie Hart

Thank you!

Paul Newcome

Happy to help. 👍️