Text to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to one data field into 2 with the space as the break in the data - I
know you can do it in excel with text to columns but is there and expresion
to do it automaticaly?
 
In a query:
FirstPart: Left([OriginalData],InStr([OriginalData]," ")-1)

LastPart: Trim(Mid([OriginalData],InStr([OriginalData],"
")+1,Len([OriginalData])-InStr([OriginalData]," ")))

Watch out for wrapping on the LastPart. It should all be in one line.
 
Back
Top