I''ve been using the same script for years to swap out names that are in reverse to first name + Last name, yet today it is only returning the number portion of the text.

For example

Smith, Jimmy

=LEFT(SEARCH(",", A2)-1)

Returns 5 instead of "Smith"

I've also used find instead of search and it still does it.

Any ideas?

Thanks

G