How do i Substitue second occurrence of a string within a cell?

[rajtak]

Hello,

Could anyone suggest how do i Substitue second occurrence of a string within a cell?

Cell A1: Port Size","","Female Port Size","1/8"

I want to substitute the second occurrence of this "," string with |(pipe). Please suggest me a formula for this.

Regards,
Raj

 

[Aladin Akyurek]

Hello,

Could anyone suggest how do i Substitue second occurrence of a string within a cell?

Cell A1: Port Size","","Female Port Size","1/8"

I want to substitute the second occurrence of this "," string with |(pipe). Please suggest me a formula for this.

Regards,
Raj

Try...

=SUBSTITUTE(A2,CHAR(34)&","&CHAR(34),"|",2)

 

[Rick Rothstein]

Aladin's formula in a more compact form (also, cell reference changed to A1 as you specified in your question)...

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