Marco to delete characters in a cell

Hello,

First at all, excuse-me for my terrible English.

I have a table which is the output of another program. In the cells ( in the same column) which contain the date and time of registration are too many characters. It's mention also the milliseconds and timezone and they disturb the import in an other program. I want to write a macro that erases the last 10 characters in that cell.

For example: 2020-12-31T17.30.20.10+01.00h must become 2020-12-31T17.30.20

It would be graet that also the T disappeared.

And at last, if there is a code that can do that. It is possible to do it on many cells in one time? One cell a time is great, the hole column in one time would be excellent.

Thank you all.

Sigpro

Please Login or Register  to view this content.

Result is also in Column B

If you want to keep it in the same Column.

Please Login or Register  to view this content.

The New Years Celebrations played a roll here. I gave you suggestions you did not ask for. You want the time also!
Do you want a separating character between date and time?

Please Login or Register  to view this content.

Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

if you want a space between the date and time

Or direct in Column A

Please Login or Register  to view this content.

Change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

if you want a space between the date and time

Originally Posted by sigpro

For example: 2020-12-31T17.30.20.10+01.00h must become 2020-12-31T17.30.20

It would be graet that also the T disappeared.

Assuming the data in Col.A

Please Login or Register  to view this content.