how do I insert a zero ie 01535-1A to 01535-01A
There are probably easier ways but you could use a concatenate formula e.g.
if the "01535-1A is in cell A1 then use:
=CONCATENATE(LEFT(A1,6),0,RIGHT(A1,2))
"Mike" wrote:
how do I insert a zero ie 01535-1A to 01535-01A
|