Need a formula to take a filename and alter the text

Options
kpierson109
kpierson109 ✭✭✭
edited 06/15/23 in Formulas and Functions

I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores.


Filename example:

JK_T1_L1_NewFile

The filename always follows this rules - 2 letters_2 letters__2 letters _filename

I would need this to populate: jk.t1.l1.newfile

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!