Text to column

T

thecuzin

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?
 
J

Jerry Whittle

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.
 
Top