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
Bookmarks