Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Replace characters in a string Replace characters in a string
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2020, 03:51 AM
Marcia's Avatar
Marcia Marcia is offline Replace characters in a string Windows 7 32bit Replace characters in a string Office 2013
Expert
Replace characters in a string 		 
Join Date: May 2018
Location: Philippines
Posts: 554
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Replace characters in a string Extract all characters from the nth number of a string Marcia Excel 2 02-24-2020 05:15 PM
Replace characters in a string Wildcard replace any string in context with a specified string wardw Word 7 05-07-2018 09:13 AM
Replace characters in a string Replace characters in a string Anthon Excel Programming 1 11-03-2016 12:48 AM
Replace characters in a string find a set of characters in a string and return a 0 (zero) if not found MaineLady Excel 2 11-05-2015 03:23 PM
Replace characters in a string Retrieve characters after nth occurence of a string veedee Excel 5 06-16-2014 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:08 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft