=left(A1,3)&1&right(A1,len(a1)-3)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ShamsulZ" wrote in message
...
Hi, can anybody tell me how to insert letter/no among a word/no. e.g.
America
i want to put 1 that become Ame1rica in the middle. Thanks friend