Hi I am trying to split a name into firstname & surname, but cant seem
to do it.

I have in say Cell A1 John_Smith

and I want to automatically have

Cell B1 John
Cell C1 Smith

Thanks