break one field into many
I want to split one field into two.How Can I do that :
for example I have a field name
Company Name: Kader rahman tonmoy
I want to split first word under FIrst Name and rest of the string under Last Name
Like below :
First Name :Kader
Last Name: rahman tonmoy
How can I solve my problem or Which string function I need to use?