CODEWITHSUNDEEP
excelexcel-formula
Niels Janssens
Niels Janssens

Reputation: 113

Is there a way to remove last characters from date column in excel?

For a function within QGIS I need to transform my datetime column into a datetime column without miliseconds.

datetime

2019-07-05T23:55:02.0000

2019-07-05T23:55:05.0000

2019-07-05T23:55:11.0000

datetime_new

2019-07-05T23:55:02

2019-07-05T23:55:05

2019-07-05T23:55:11

Could you guys help me with this issue?

I tried to use the =LEFT(column, LEN(column)-5) but it gives me an error

EDIT: Appears to be a language issue, I was not able to use the LEFT or MID calculation while my excel version is DUTCH.

Upvotes: 0

Views: 838

Answers (1)

Plato77
Plato77

Reputation: 432

Assuming that the data is always the same length (with a value in cell D6), you could use =LEFT(D6,19)

Upvotes: 1

Related Questions