Add a leading letter to existing column values IF
I have a column that contains project ID numbers. I want each project ID to begin with the letter M. Some of the values in this column already begin with M - for example, M12345. Other values in the column do not begin with M - for example, 12345.
I would like to apply a formula that will add a leading M to each value if the value does not already begin with M. Is this possible?
Help Article Resources
Check out the Formula Handbook template!