Hi there,

Spanking new to the forum here, sorry if this isn't the right place to post. Figured this might be a VBA task...

I need to reformat Lat Long data as follows:

Source Cell contains, as an example:

36 33 24.67849(N) 105 25 01.00930(W)

I need to generate 2 cells with a format:

36332468N and 105250101W

Note the need to round the decimal seconds to 2 places, then remove the decimal point.

I'm not much of a programmer, but would rather avoid brute forcing this by hand to avoid data entry errors.

I appreciate the help, and if theres a better forum for this question, I'm all about reposting elsewhere. Thanks!