I
Ivan Grozney
There is a way in VB code but I don't know if it will work
in a query. It would look for the blank and then separate
it out. However if some have a middle intial or name
or ??? it might not work the way you want.
If there aren't a lot of them I would think I would take
that "column" to word, replace the spaces with tabs and
then put it back into excel and import the data to your
database. Good luck
in a query. It would look for the blank and then separate
it out. However if some have a middle intial or name
or ??? it might not work the way you want.
If there aren't a lot of them I would think I would take
that "column" to word, replace the spaces with tabs and
then put it back into excel and import the data to your
database. Good luck