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! Go to Solution.
This?
INDEX(SPLIT([column], ": "), 1)
Replace column
with the name of the column containing the concatenated value.
This?
INDEX(SPLIT([column], ": "), 1)
Replace column
with the name of the column containing the concatenated value.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |