troubleshooting Question

Normalizing values in cells with formula in Excel / Google Sheets

Avatar of Doug Van
Doug VanFlag for Canada asked on
* Google SuiteGoogle* google spreadsheetsMicrosoft ExcelMicrosoft Office
9 Comments3 Solutions16 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.

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
Ron Malmstead

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
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 3 Answers 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