inserting characters into cells

[ash_the_fish]

Hi all,

This is my first post as a new member. I apologise if I've posted this into the wrong topic area - I'm not sure if this is a programming question...

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

MANY MANY thanks in advance.

Regards,
Ashley