How to create a list of quoted text

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 Solved
0 2 71
1 ACCEPTED SOLUTION

'"' & SUBSTITUTE( Sheet2[Month] , " , " , '" , "' ) & '"'

View solution in original post

2 REPLIES 2

'"' & SUBSTITUTE( Sheet2[Month] , " , " , '" , "' ) & '"'

Thanks @Marc_Dillon 

Top Labels in this Space