Advice on How to Subsitute/Replace a Text or Number

Hello All,

I'd like your advice on to use the functions substitute or replace in excel with few examples. Of course, I already went to the Excel Help base, but their examples didn't suffice me.
Basically, let's assume I want to replace a specific word in a cell which is comprised of two words, or comprised of only one word.
What functions would work best to do that and would this work on numbers as well?

Assume that:
A1: Paris France ---> How to you remove Paris in the 1st place and Secondly, How do you keep Paris and remove France.
---------And
A2: Paris France ---> How do you remove Paris and replace it by Monaco (keeping France),

Thank you guys, any link to this matter would be much appreciated

Both require Substitute:

=Substitute(A1,"Paris","")

=Substitute(A1,"France","")

=Substitute(A2,"Paris","Monaco")

if Paris (or France) appears more than once and you want only to change first, add 1 as a 4th argument.

Excellent, Thanks. I was waiting for you to reply to this post

Last thing, is the above answer valid to substitute numbers as well?

Cheers

Yes.. numbers don't get put in quotes, though.