Split a string where the space is???

Hi All

I'm trying to split the string in textbox 1 so i get the first name and the last name but this doesn't seem to work?

Please Login or Register  to view this content.

i think it's do do with the "find" part as this has a different use with VBA than in a formula.

any help is appreciated!!

cheers

Use the Split Function

Please Login or Register  to view this content.

Thanks Roy,

i wasn't aware of the split function

appreciate the help

It can be very useful, remember it builds an array so components will start from zero