Parsing Text Separated by A Space

I have a list of names and addresses as follows:

700 Main Street

I would like to parse the information with street name
( Main Street ) in one field and street address ( 700 )
in a separate field.

Street number and street name are varied in length
throughout the list.

Is it possible to parse everything to the left or right of
the space?

Thanks