I admire how literal you were and apologize for not being more precise in my definition.

Arbitrary cell (A1) containing 36 33 24.67849(N) 105 25 01.00930(W) must be converted to two separate arbitrary cells (A2 B2), where arbitrary A2 contains the Lat portion, and arbitrary B2 contains the Long portion.

The VBA spits out appropriate values it seems. It feels like I would need one UDF like a =Lat(A1) and a =Lng(A1) to place in to separate cells.