Add leading zeros based on IF text

[bosco72]

I need either a foumula or macro to add leading zeros to a number based on text in another column

Column A is the original number
Column B is blank and where I want my result to go leaving column A original
Column C is where the text is that the leading zeros will be based on

A1 = 14M3652100
B1 = Blank
C1 = If this column has text "ASP" or "POSMOS" or "ANISON" I need B1 to result in 0014M3652100

Thanks for any help. Sounds easy but I am new at this......

 

[par60056]

You don't say how many leading zeros. Is it the same for all 3? Is it to make the string a certain length?

You can start with something like:
B1= =if(or(C1="ASP",C1="POSMOS",c1="ANISON"),"00"&A1,A1)

 

[bosco72]

Yep it's 2 zeros, no not to make a certain length it needs to have those 2 zeros to make a certain format so when we search in an external system those with the ASP, POSMOS or ANISON need to have the zeros added in order to find them. that formula worked great! Thank you!

 

[par60056]

glad I could help. Thanks for the feedback.