Back to Browse

Macro Monday Function to Remove Characters with 3 Solutions

2.3K views
May 2, 2017
8:34

Grab the Free VBA Quick Reference Guide https://www.chrisjterrell.com/excel-vba-quick-reference-guide/ In this Macro Monday challenge create a function that removes characters \ / * [ ] : ? Code Function SheetString(Name) 'Name = Application.WorksheetFunction.Substitute(Name, "\", "") 'Name = Replace(Name, "\", "") s = Split("\,/,*,[,],:,?,90", ",") For r = 0 To UBound(s) Name = Replace(Name, s(r), "") Next SheetString = Name End Function

Download

0 formats

No download links available.

Macro Monday Function to Remove Characters with 3 Solutions | NatokHD