Dear Community
I am looking for a solution to extract just date information from below values.
KW1_MDA_AllAvailable_10-01-2022_14-18-11
KW13_MDA_AllAvailable_04-04-2022_08-06-48
KW25_MDA_AllAvailable_27-06-2022_08-10-43
The formula will need to produce below outputs
10-01-2022
04-04-2022
27-06-2022
Anyone who can help ?
解決済! 解決策の投稿を見る。
@kenan_turker two methods here:
One uses RegEx:
One uses the Text to Columns:
1) Use delimiter as _
2) Select columns you want: