Making features in excel and removing unwanted characters

8/29/2016 - 8:59 PM

=UPPER("CODEHERE_"&(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(C567,14)," ",""),"-","_"),".","_"),"&",""),",","")))

Cacher is the code snippet organizer for pro developers