Hi I am attaching a file I need help with a formula that will be able to split a name with middle name and surname that is separated by a space
say for exampla in the cell the following name will appear
Geetangali Angali Singhpaul
to be separate as follows
g e e t a n g a l i a n g a l i s i n g h p a u l
the firstname would be to a max of 2 o characters and the mid space surname to be max 40 characters
Thank you in anticipation
Regards
Rajan