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

PilotsWife87

New Member
Joined
Aug 8, 2019
Messages
2
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,500
Office Version
365
Platform
Windows
Welcome to the Board!

Try this:
Code:
=TRIM(SUBSTITUTE(SUBSTITUTE(CONCATENATE(D3," ",C3," ",E3),"20",""),"Van",""))
 

PilotsWife87

New Member
Joined
Aug 8, 2019
Messages
2
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!!
 

Forum statistics

Threads
1,082,478
Messages
5,365,792
Members
400,852
Latest member
katedun

Some videos you may like

This Week's Hot Topics

Top