Remove letters from left in formula

[dodde]

Hello

I have this formula, and i want to remove Dato:, in this Dato: 08.11.2019, how can i inplent Len in the formula or is it another way to do it, D2 return t his value

it is a link from a cell on a WB in another folder

='[S3007A-12 Kappeliste-Partlist.xlsx]Partlist'!$D$2

[dodde]

Hello

or can i use If Left in some way

[AliGW]

Maybe:

=MID('[S3007A-12 Kappeliste-Partlist.xlsx]Partlist'!$D$2;8;10)

[dodde]

Hello

Thanks