CountIF function Help

[lwilt]

I'm having trouble with the countif function. In my spreadsheet in column C starting cell C2 I have text numbers. If the cell starts with an 8 I want to put a leading 0 in front of it otherwise I want to keep the cell the way it is.


Also, if possible for the cells with just a 0 in them can I turn have it write those as null cells where the function is running?

thank you

 

[lwilt]

Also posted at:

https://www.excelforum.com/excel-general/1196543-countif-function-help.html#post4718711

https://www.mrexcel.com/forum/excel-questions/1018381-countif-function-help.html#post4886921

 

[Hui]

sample file please?

 

[lwilt]

The original doc is coming from a web excel file so I'm converting the number numbers to text before using the formulas I've tried and I'm not sure if that is causing me issues.

 

[lwilt]

Solved!!!

here was the solution
=IF(OR(C2={"","0"}),"",IF(LEFT(C2,1)="8","0"&C2,""&C2))

 

[Syedali]

try this

=IF(OR(C2={"","0"}),"",IF(LEFT(C2,1)="8","0"&C2,""&C2))

 

[lwilt]

also worked for me thank you