It might have helped if I included the formula.

=LEFT(A1,20)&"-" & RIGHT(A1,LEN(A1)-10)

Regards,
Paul

"PCLIVE" wrote in message
...
Use a helper column. If your data is in column A (beginning at A1), then
in another column (Z1 for example) enter the following formula and copy
down as needed.

HTH,
Paul

"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:74f6e21805dec@uwe...
I have large number of coding data like this (K4115KBA02WB005) these are
15
digits, what i want is to enter - sign after 10 digit (like
K4115KBA02-WB005).
please tell me some short way.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1