Hi!
In a table Sheet2, I have a column named "Month" with values of type text: january, february, march....
In a virtual column, I would like to get the list of months like this: "january", "february", "march",...
I've used Sheet2[Month] but it gives a list january, february, march....without the quotes for each month.
How can I achieve that? Thanks
Solved! Go to Solution.
'"' & SUBSTITUTE( Sheet2[Month] , " , " , '" , "' ) & '"'
'"' & SUBSTITUTE( Sheet2[Month] , " , " , '" , "' ) & '"'
Thanks @Marc_Dillon
User | Count |
---|---|
37 | |
30 | |
29 | |
22 | |
18 |