Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove dates is the middle of a line
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove dates is the middle of a line
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 "jason2444" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove dates is the middle of a line
Try this:
=REPLACE(A1,FIND("-",A1)-3,6,"") "jason2444" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove a space from the middle of a line of numbers? | Excel Discussion (Misc queries) | |||
How can I stop a line in the middle of a chart? | Charts and Charting in Excel | |||
how to remove spaces in a middle of a cell example '25 566 589. | Excel Discussion (Misc queries) | |||
Remove middle initial from "first name middle initial" | Excel Discussion (Misc queries) | |||
In a chain of links, how can I automatically remove the middle lin | Excel Discussion (Misc queries) |