Split or Inverse expresion of Cocatenate? Help with Expressions

I have a column that is a Key. A Concatenate of two colums: CONCATENATE([Racing Date],": ",[Track]). So in F.E. 23/08/2021 : CHURCHILL DOWNS.

Is there any formula for a virtual column to extract the Date?

Solved Solved
0 1 111
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

This?

INDEX(SPLIT([column], ": "), 1)

Replace column with the name of the column containing the concatenated value.

View solution in original post

1 REPLY 1

Steve
Platinum 4
Platinum 4

This?

INDEX(SPLIT([column], ": "), 1)

Replace column with the name of the column containing the concatenated value.

Top Labels in this Space