Function to parse street number and name /Function to parse out date

I have a value that gets imported as follows: 1970-03-15T00:00:00

I would like to manipulate it to read mmddyyyy, 03151970.

Also, I have a address that gets imported as follows: 123 Elm St.

I would like to parse out street number into 1 cell, and street name into another.

Any help would be appreciated.
Thanks

To get date

=MID(A1,6,2)&MID(A1,9,2)&LEFT(A1,4)

For Streets please post a sample file as street names are not usually as simple as your example.