Hi all,
Below I have attached one sample Data. Need to Extract the Month and the Year from the data.
Required Output: April 2023, May 2023, June 2023
Solved! Go to Solution.
Hi @DataPirate26 ,
How about this formula? I hope this helps.
Formula Tool
Year = GetWord([ team Comments], CountWords([ team Comments])-1)
Month = GetWord([ team Comments], CountWords([ team Comments])-2)
Output = [Month] + " " + [Year]
Output image
@DataPirate26 One way of doing this