"Elkar" wrote in message
...
Try this:

=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,1024)

This basically replaces all spaces in your text with the ~ tilde
character,
except the last one.

Actually, it only replaces the last space with tilde.