Reply to thread

Message: [QUOTE="Mike H, post: 6358660"] Hi, You can't do that with code or a formula unless there is some regularly repeating pattern in the frequency of first_name - last_name. for example take the name Michael Michael Michael (my first name) Michael ( a very common surname) there is no way to programatically decide which is which is which. You can do the split programatically by using the instr function and looping through the names but will end up with the same problem as with the formula. Mike [/QUOTE]