Truncate Name

E

ernestgoh

Hi, how do I extract the first names from the various cells? I hav
thousands so it is impossible to do it manually. Thanks in advance!

For example
A1 = John Waters. Should be John.
A2 = Barry Johnson. Should be Barry
A3 = Fredderick Rogers. Should be Fredderic
 
Top