Is your text always structured like this?HvH-Ab-150512-06
Changed to this--->150512
Here is the format the date will change depending on the day
You can do it using Excel's Replace dialog box using the same two replacements that I used in the macro below...Yes it is always structured this way and its all in one column and its not always the same amount of rows and so therefore it should be in macro I think
Sub DateOnly()
Columns("A").Replace "*-*-", "", xlPart
Columns("A").Replace "-*", "", xlPart
End Sub
Im guessing I plug in my parameters somewhere in here I don't quite understand the format
Sub DateOnly()
Columns("A").Replace "*-*-", "", xlPart
Columns("A").Replace "-*", "", xlPart
End Sub