View Single Post
 
Old 05-04-2020, 03:51 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

[QUOTE=
The worksheet formula equivalent might be along the lines of:
=SUBSTITUTE(PROPER(SUBSTITUTE(TEXTJOIN(",",TRUE,E3 :G3),"-","qzqzqz")),"qzqzqz","-")[/QUOTE]

I applied this formula and it is perfect, though I limited the "qzqzqz" to just "qz".
Reply With Quote