Remove punctuation from string

[BRISBANEBOB]

I have a list (coulumn 'C') of surnames names followed by initials, and I am extracting the surnames using the formula =LEFT(C239,FIND(" ",C239)-1). This works fine except that some of the names have a comma after the surname and before the initials. I know I can use a "find and replace" to get rid of the commas, but is there any way I can eliminate them using a foruma, preferably as part of the above formula?

Thanks for any ideas

[mdbct]

You can use the Substitute function for this

Please Login or Register  to view this content.

[BRISBANEBOB]

Beautiful. Once you'rs shown how, oh so easy!

Thanks and regards