Replace the last occurence of space with #

[YasserKhalil]

Hi everybody
I want to replace the last occurrence of space with #
for example
You will help me I'm sure
Should be :
You will help me I'm#sure

 

[pgc01]

Hi

Try:

=SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))

 

[YasserKhalil]

Thank you very much
It works very well

 

[pgc01]

You're welcome. Thanks for the feedback.