if James Hansson is in A1, then
=LEFT(A1,FIND(" ",A1)-1) will give you James and
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) will give you Hansson

or you could use the Text to Columns feature.

--
Gary's Student


"ladyhawke" wrote:

I would like to read a string based on a db query (like select Names
from NameTable where Name Like '%James%') and take each resulting
string and devide then into different cells...

E.g. James Hansson - A1=James and B1=Hansson

How can this be done? I can get as far as using querytables and show
the results in the current sheet but thats not what I want.

//Ladyhawke