Text with formula

[srizki]

I need to add C11701103 between the two dots, between 2016 . . BIL. (there is no space between 2016..bil.[TABLE="width: 128"]
<tbody>[TR]
[TD="width: 128"]31-Aug-2016..BIL[/TD]
[/TR]
</tbody>[/TABLE]


I have over 5000 entries in the column with different dates. So I need the formula to insert C1171103.

Please advise,

Thanks

 

[Tetra201]

Will this work for you?

=SUBSTITUTE(A1,".BIL","C1171103.BIL")

 

[srizki]

Yes, it is working,
Thank you very much.

 

[Tetra201]

You are welcome.