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:

[TABLE="class: cms_table"]
<tbody>[TR]
[TD="class: cms_table_xl66, width: 144"]

<colgroup><col width="144"></colgroup><tbody>
[TD="class: xl66, width: 144"]2014 Great Dane Van
[/TD]

</tbody>

[/TD]
[TD="class: cms_table_xl65, width: 46"][/TD]
[/TR]
</tbody>[/TABLE]


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!!
[TABLE="class: cms_table"]
<tbody>[TR]
[TD="class: cms_table_xl65, width: 100"][/TD]
[TD="class: cms_table_xl65, width: 46"][/TD]
[/TR]
</tbody>[/TABLE]

 

[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