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 […]