Add or Remove Text from Cell

I have an import from a system that looks like the below. I need to standardize the data in another row with either all prefix 'Nav-xxx' or all excluding 'Nav-'. Any idea how to do that???

Thanks in advance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!