LEFT Function

Owen Smith · 05/14/21

I want to add a "0" to the left of any number with just 5 digits and just duplicate any number with "H" in front.

Paul Newcome · 05/14/21

Ok. Let's try this instead:

=IF(LEFT([Column2]@row) = "H", [Column2]@row, "0" + [Column2]@row)

Paul Newcome · 05/14/21

Try something like this...

=IF(LEN([Column2]@row) = 5, "0") + [Column2]@row

Owen Smith · 05/14/21

That works great for the example I provided. One exception and rather important that I failed to list, a standard five digit number could have an extension, like "XA", ie.45232XA, making length 7. I was working with contains to duplicate when includes a "H". Thank you for the quick reply.

Paul Newcome · 05/14/21

Ok. Let's try this instead:

=IF(LEFT([Column2]@row) = "H", [Column2]@row, "0" + [Column2]@row)

Owen Smith · 05/14/21

Thank you Paul, I added the OR and it seems to work for all

Paul Newcome · 05/14/21

Happy to help. 👍️

LEFT Function

Best Answer

Answers

Help Article Resources

Categories