A)
if the data length is fixed, you can use LEFT & RIGHT functions.
Means if 10 length is fixed for data, hope the following will resolve your query.

if your data is in column A and starts from row 2 (A2)
in first column use =left(a2,10) and in other column use =right(a2,10).

B)
in Office 2013, if your data is in first column and starts from A2, Flash Fill can resolve your problem.
type the data N34 27.576 and use CTRL+Enter.