I get that the following forumla can tell me the position of the first space from the right. Can I make it replace that space with a comma or semicolon or something? I understand this... JUST enough to be dangerous but cant seem to make something that will perform this duty. i would really really appreciate it!

=FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1," ",""))-0))