Is it possible to convert the "4d" (identified as a text) in the "Duration" column to a number 4?

Sibali_B · 06/09/22

Mike TV · 06/10/22

=VALUE(LEFT([Column5]@row, 1))

Replace [Column5]@row with whatever position the column is that you want to modify.

Mike TV · 06/10/22

=VALUE(LEFT([Column5]@row, 1))

Replace [Column5]@row with whatever position the column is that you want to modify.

Sibali_B · 06/10/22

It works! Thanks!

JRodriguez · 04/08/24

that only works if the duration has one digit, right ?

Best Answer