Replace

[dodokh]

Hello,

I have A1: One Thousand JOD and 25 Fils

I need a formula in B1 to replace JOD to be SAR and Fils to be Halala

Thank in advance.

 

[mikerickson]

The SUBSTITUE function will do that.

 

[dodokh]

The SUBSTITUE function will do that.

let me try .. thank you.

 

[VoG]

Like this

=SUBSTITUTE(SUBSTITUTE(A1,"JOD","SAR"),"Fils","Halada")