Love your videos - maybe I missed it but I don't think you mentioned that this is still in beta testing phase and not available to most of us who are not microsoft insiders - or is it just me?
Thanks for your kind note. According to the Microsoft blog post about these functions, they are currently available to Beta Channel users running Windows: Version 2406 (Build 17715.20000) or later, or Mac: Version 16.86 (Build 24051422) or later. More info here: insider.microsoft365.com/en-us/blog/new-regular-expression-regex-functions-in-excel
Thanks for your calendar build vid! Having prob showing multiple events per day in nicely lined up single lines per event. Would regex be good to delete the commas? I'm trying courier font to get events to not wrap... Is there a better way? Thank you!
Not tested, just a theory. You could probably use the regex replace and replace the commas with CHAR(10). That's the line break character. But I haven't used regex, but I'm guessing it would only replace the first comma?
Thank you ❤
Great job Jeff I have started to understand it with this video
Thanks
Jeff, Thank for the video; but I think I'll stay with flash-fill as it seem less problematic. best regards from chicago
Love your videos - maybe I missed it but I don't think you mentioned that this is still in beta testing phase and not available to most of us who are not microsoft insiders - or is it just me?
Thanks for your kind note. According to the Microsoft blog post about these functions, they are currently available to Beta Channel users running Windows: Version 2406 (Build 17715.20000) or later, or Mac: Version 16.86 (Build 24051422) or later. More info here: insider.microsoft365.com/en-us/blog/new-regular-expression-regex-functions-in-excel
Thanks for your calendar build vid! Having prob showing multiple events per day in nicely lined up single lines per event. Would regex be good to delete the commas? I'm trying courier font to get events to not wrap... Is there a better way? Thank you!
Not tested, just a theory. You could probably use the regex replace and replace the commas with CHAR(10). That's the line break character. But I haven't used regex, but I'm guessing it would only replace the first comma?