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 |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |
Type a product name