Inserting Characters Into Cells

I have recently purchased a new GPS for my fishing boat. I am trying to transfer my old coordinates from one unit to the other. I am using a .csv file to achieve this. Can some kind please let me know (and possibly tell me) if there is way to insert characters and spaces in to multiple cells. I have over 800 individual coordinates to modify to the new gps and this would take a long time to achieve individually.

I need to replace this: 12.34.567 to this: 12 34.567 N

and this: -1.23456 to this: 001 23.456 W