Replace Function...What if there are duplicate letters?

[PP3321]

I want to insert ' (apostrophe) in front of letter E in the string.

E10A10E10
↓↓↓
'E10A10'E10

The following code will only add apostrophe in the 1st occurrence.

=REPLACE(A1,SEARCH("E",A1),0,"'")

Is there a way to insert apostrophe to every occurrence of letter E within the string...?

Thank you...

 

[Vishal Srivastava]

I want to insert ' (apostrophe) in front of letter E in the string.

E10A10E10
↓↓↓
'E10A10'E10

The following code will only add apostrophe in the 1st occurrence.

=REPLACE(A1,SEARCH("E",A1),0,"'")

Is there a way to insert apostrophe to every occurrence of letter E within the string...?

Thank you...

Hi,
Try this
=SUBSTITUTE(A1,"E","'E")

Thanks & Regards,
CMA Vishal Srivastava

 

[PP3321]

Wow Vishal thank you so much!!!