remove dates is the middle of a line

J

jason2444

have a file full of lines like this Reg. Cab Long Bed 03-07 "Classic"

is there a way to remove the 03-07 from the middle of a line?
 
T

Toppers

If dates are all of the format of your example (yy-yy) then try:

=LEFT(A1,FIND("-",A1)-3) & MID(A1,FIND("-",A1)+3,255)

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make elements in a row space between instead of wrapping when choosing multiple columns 0
Removing Line Numbers 4
Small Thick "Bar" Below Last Typed Line ? 0
Reverse Index Match 2
Combining three files when middle file has sections with endnotes 2
Word VBA - Want to test if Full Name is NOT Present in document 0
Convert Text to Date Month and Year 1
Weekend dates conditional format 3

Top