Need a formula to take a filename and alter the text

kpierson109

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

Paul Newcome

Try this:

=LOWER(SUBSTITUTE([Column Name]@row, "_", ""))

Paul Newcome

Try this:

=LOWER(SUBSTITUTE([Column Name]@row, "_", ""))

kpierson109

Got it! Thank you! I was using and IF function and then nesting the LOWER and SUBSTITUTE. I overcomplicated it.

Paul Newcome

Happy to help. 👍️