Combine Two Functions

[Memar]

Hi All,

How can I combine two functions below? I want to add space between the first name and last name and I also need to delete the numbers ,which exported,before the last name.

=RIGHT(H98,LEN(H98)-SEARCH(" ",H98))
=SUBSTITUTE(G98,","," , ",1)

Exported Data - C104056 LoveCraft,Terry

Desired result - LoveCraft, Terry

Thanks for your time and help!

 

[Excelestial]

=substitute(right(h98,len(h98)-search(" ",kh98)),",",", ")