Excel formula to replace first occurrence of a character

Question

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

Answer 1

One more option: (with data in A1):

=SUBSTITUTE(A1,"|",",",1)

You can't replace existing data with forrmula, so you need to create another column. You can then cut and paste as values to replace existing data.