Please see attached (2018.2) workbook and below screenshots for changes made. SPLIT function works well with your problem. If this answers your question please mark this response as correct. Thx, Don
After SPLIT function, set from string to Number (Decimal) for each:
Set to appropriate geographic role:
Set to their geographic roles:
Convert from measure to dimension:
Rename to Lat or Lon as appropriate.
When Lat/Lon are placed on row/column you'll see only 1 point. See following to disaggregate the data:
Click Analysis and uncheck this box.
You'll now be able to drag dimensions to use size/color and fill out your map:
Map viz.twbx 544.5 KB