Solved: Removing certain string

[lienlee]

IA490 Leadtimes - Path & Leg (IA1a).doc
IA490 Leadtimes - Path and Leg (IA001b).doc
IA490 Leadtimes - Path & Leg (IA1c).doc
IA490 Product - PMBasic.doc IA490 Product Update - AOM (IA002b).doc
IA490 – Product Reverse Logistics - GENCO (IA2c).doc
IA 490 Item - Manu (IA2j).doc
IA490 Product - ProFusion.doc
IA490 Fixture Products (IA2n).doc
How can i code it removes all the.doc in the column and puts the new data onto the next column.

[GTO]

Presuming data in B2: =SUBSTITUTE(B2,".doc","")

[lienlee]

Presuming data in B2: =SUBSTITUTE(B2,".doc","")
Thanks.