how do I insert a zero ie 01535-1A to 01535-01A

[Mike]

how do I insert a zero ie 01535-1A to 01535-01A

 

[DMcCormack]

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))

 

[Markus Fischer]

The simplest way would be to use the SUBSTITUTE function:

if your code is in cell D5 -> "=SUBSTITUTE(D5,"-","-0")"

This is however quite simplistic, and will introduce a 0 even if there was
already one after the hyphen.

Please let me know if you want something more complex.

Markus

 

[JasonP CCTM LV]

Click on the cell that contains 01535-1A, hit F2 (this will let you edit
inside the cell) and type in the 0.

 

[Bruce Sinclair]

The simplest way would be to use the SUBSTITUTE function:

if your code is in cell D5 -> "=SUBSTITUTE(D5,"-","-0")"

This is however quite simplistic, and will introduce a 0 even if there was
already one after the hyphen.

Please let me know if you want something more complex.

The various answers are fascinating ... and mine would be different again.
*Assuming* that the only place in your data that you have a - is where you
want the 0 inserted, select the data to work on and find '-' and replace
with '-0'.