Hi Forum,

I am seeking to create a macro that is able to delete all the remaining characters after the 10th character in each cell. So I wish to only have the first date listed in each cell, and hence delete all the remaining dates.

I know this is manageable when using regular excel-build in functions. But I would really like to see how it is done in VBA. Any ideas how that would look like?

Br
vba problem.xlsm