Thread
: [Solved]
Replace characters in a string
View Single Post
05-04-2020, 03:51 AM
Marcia
Windows 7 32bit
Office 2013
Expert
Join Date: May 2018
Location: Philippines
Posts: 527
[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".
Marcia
View Public Profile
Find all posts by Marcia