I understand that it's not possible to import degrees, minutes, and seconds format of lat/long into ArcGIS. I have a client who has all their data in an Excel spreadsheet in degrees, minutes, seconds.
First, may I just confirm that it's not possible to import degrees, minutes, seconds format into ArcGIS.
Second, what is the best way to convert the data in Excel? I have written a function that converts the data for the client so that it may be imported into ArcGIS. But I am not sure if this is the most efficient way to handle the problem. They seem reticent to collect the data in decimal degrees because they have always been collecting the data in degrees, minutes, seconds.