Multiple SUBSTITUTE Function To Replace Square Bracket with Single Pipe

Welcome to Excel Jet Consult blog post. In this tutorial, we going to see how to substitute square brackets with single pipe. Let’s get started   SUBSTITUTE Function The SUBSTITUTE Function replaces existing text with new text in a text string Syntax:         =SUBSTITUTE(text, old_text, new_text, [instance_num])   Sample Data In the caption below, we have Account Manager’s […]

Continue reading