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

D

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

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
 
J

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.
 
B

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.
Click to expand...

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'. :)
 
Top