title: Excel formula to replace first occurrence of a character
body: <p>I am new to excel, I have a data of 1000 rows with each row looks like <code>435362|A|B|C</code> I want a formula in excel which modifies each rows so that the data looks like <code>435362,A|B|C</code> i.e. it should replace first occurrence of | with comma(,).</p>