"Gary''s Student" wrote:

Try:

=LEFT(A1,5) & "-" & RIGHT(A1,LEN(A1)-5)
--
Gary's Student


"fitzu" wrote:

I need to add a - after the first 5 digits can get it to work with numbers
but not with letters & numbers

Hey How abt if I want to do the other way round, get rid of the dash"-" in
between?