I am trying to format a number of different coordinates in to one "master" format. One format that was given to me is: 38°15′46″N and 121°55′39″W. Another format is this: 37-25-30 and 098-04-07. And yet another format: -97.9122222,37.4644444. I would like to have them all formatted in to the decimal format, but with the latitude in one cell and longitude in another cell.

I appreciate any help.