How to remove certain parts of text in an already concatenated column

[PilotsWife87]

Good Morning,
I need to remove certain text from my line that has already been concatenated.
For Example...This is the concatenated version:

2014 Great Dane Van <colgroup><col width="144"></colgroup><tbody> </tbody>

<tbody>
</tbody>

I need to remove "20" and also remove the word "Van" in this column to where it only reads "14 Great Dane".
My original concatenate formula for this column is
=CONCATENATE(D3," ",C3," ",E3)

All help is greatly appreciated in this matter!!

<tbody>
</tbody>

 

[Joe4]

Welcome to the Board!

Try this:

=TRIM(SUBSTITUTE(SUBSTITUTE(CONCATENATE(D3," ",C3," ",E3),"20",""),"Van",""))

 

[PilotsWife87]

Thank you so very much!! I appreciate your help! I've been trying to figure this out for a few hours now. You're the best!!

 

[Joe4]

You are welcome.

The key is the SUBSTITUTE function.
To read up more on it and see examples, see: https://exceljet.net/excel-functions/excel-substitute-function