I forgot how to trim

[makinmomb]

MML 25 X 35 = MML WM290A ARIEL SNOW WHITE I want to removed the word MML which appears after the = sign

<colgroup><col width="444"></colgroup><tbody>
</tbody>

Result after trim

MML 25 X 35 = WM290A ARIEL SNOW WHITE

 

[WarPigl3t]

...

 

[makinmomb]

formula

Though this time find replace did the work

Find = MML
Replace =

 

[Br0ck]

Try...

=TRIM(SUBSTITUTE(A1,"MML","",2))

 

[Rick Rothstein]

Another way...

=SUBSTITUTE(A10,"= MML","=")

 

[makinmomb]

Another way...

=SUBSTITUTE(A10,"= MML","=")

Taken both answers thanks , though I will take that of Ricks ,
I used the same logic for Find and Replace ALL but wanted the
same formula wise too