troubleshooting Question

Normalizing values in cells with formula in Excel / Google Sheets

Avatar of Doug Van
Doug VanFlag for Canada asked on
Microsoft OfficeMicrosoft ExcelGoogle* Google Suite* google spreadsheets
9 Comments1 Solution12 ViewsLast Modified:
Hello all,
I thought this be trivial but I'm just not finding the right solution.

I have a column of cell entries where there are occasion input errors for the non-numerical portion of the values. So, I want to automatically correct these errors.

Examples:
Input value / Corrected input value)
C005 / C005 (already correct)
CT021 / C021
044 / C044
33 / C033

In other words, the correct value is always going to be in the format, "Cxxx". Where xxx = 000 - 999. The leading zeros are important.

Thank you
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros