Reader Len Daniels faces a frustration with mapping apps. He writes:

1. Sort Multiple Gps Addresses Online
2. Sort Multiple Gps Addresses For People

Much as I love the ability to navigate using Apple’s Maps and Google Maps with my iPhone while driving, I’d like the option to create routes with multiple destinations. I often visit one client after another and it would be convenient to create a single route that moves from one to the next. Is there a way to do that with either of those apps?

How do I map a list of addresses? Maxwell asks: I’m trying to punch in multiple locations like 60-80 addresses in the US at a time and be able to see those locations on my computer. Batch Geocoding: Converting Addresses to GPS Coordinates.

Regrettably, no. In the case of Apple’s Maps app it’s not entirely surprising given that the OS X version also supports just a single destination. Google Maps inability to do this is more puzzling as its web-based counterpart does let you create multi-destination routes. Although you can send links to these routes to your iOS device and open them in the Google Maps app, only the beginning and end of your journey are displayed. Open these links in Safari and you do see the route with all its destinations, but you don’t get the benefit of turn-by-turn navigation.

Disappointed though you may be that the two most popular mapping apps available to iOS devices lack this feature, you can take some comfort knowing that there are alternatives.

Though not cheap at $50, Garmin’s Navigon North America lets you create routes with multiple destinations. To do that on an iPhone, tap More at the bottom of the screen, tap Route, tap the plus (+) button, and then take the necessary steps to create your first destination. Once you’ve done that tap Add to Route at the top of the screen. Tap the plus button again and create another destination. Repeat this process for all your destinations. When you’re done, tap the calculate button and Navigon will create your route profile (which includes the route’s total distance and the time it will take to complete it).

An initially less expensive way to go about it is to purchase MotionX GPS Drive for 99 cents. For that penny-under-a-dollar purchase you get the app and 30 days of free voice guidance. Once those 30 days expire you’ll have to pay for your virtual voice navigator to the tune of $9 a year for an auto-renewing subscription, $10 for a flat one-year plan, or 30 days of voice guidance for $3.

I find MotionX’s method for adding destinations (which it terms “multi-stop routing”) a little less intuitive in that it asks you to first create and calculate your final destination and then locate additional destinations and add them as stops, but the process is hardly onerous.

These aren’t the only apps that do this sort of thing. If there are any that you particularly like, feel free to mention them in the comments below.

Have a question of your own? Send it along to mac911@macworld.com.

>How to sort addresses by street name/number in Excel?

Let’s say you have a list of addresses of your clients in a worksheet, and you want to sort these addresses by their street name. So how can you quickly sort your clients’ addresses by street name/number in Excel?

Recommended Excel Productivity Tools

Bring tabbed editing and browsing to Office (include Excel), much more powerful than the browser's tabs. Free Download..

More than300 powerful advanced features for Excel, designed for1500 work scenarios, save70% time for you. Free Download..

Sort addresses by street name with a help column in Excel

Sort addresses by street name in Excel, you need to create a help column first.

1. Select a blank cell adjacent to the address list, and type this formula =MID(A1,FIND(' ',A1)+1,255) (A1 is the cell of your address list), and press Enter button, then drag the fill handle to fill the range you want. After that, you can see all addresses are extracted to the help column except the street numbers.

2. Then select the help column range, and click Data > Sort A to Z. See screenshot:

3. In the Sort Waning dialog box, check Expand the selection. See screenshot:

4. Click Sort, you can see the addresses are sorted.

Sort addresses by street number with a help column in Excel

If the addresses are with the same street, and you want to sort them by the street number, you can do as these: Steinberg wavelab pro 9 torrent.

1. Select a blank cell which is adjacent to the address list, and type this formula =VALUE(LEFT(A1,FIND(' ',A1)-1)) (A1 is the first cell of your address list), and press Enter button, then drag the fill handle to fill the range you want. After that, you can see only the street numbers are extracted to the help column.

2. Then select the help column range, and click Data > Sort A to Z. See screenshot:

3. In the Sort Waning dialog box, check Expand the selection. See screenshot:

4. Click Sort, you can see the addresses are sorted.

Tip: You also can use this formula =LEFT(A1,FIND( ' ',A1)-1), too.

Note: This method also can work when the streets in the addresses are different.

Relative Articles:

Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

• More than300 powerful advanced features, designed for1500 work scenarios, increasing productivity by70%, give you more time to take care of family and enjoy life.
• No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
• Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,
• Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
• 110,000 highly effective people and 300+ world-renowned companies' choice.
• 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

• Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!

Sort Multiple Gps Addresses Online

Sort Multiple Gps Addresses For People

• How to separate or remove company name from address (not email address). i have an issue while cleaning the address there are company name in address please give me a solution.
• To post as a guest, your comment is unpublished.
  Just used this method on a single street address column data (i.e. 100 Main Street) And it worked like a charm. THANK YOU! Excel 2016.
• To post as a guest, your comment is unpublished.
  It worked once but doesn't anymore. Is it outdated?
• To post as a guest, your comment is unpublished.
  I have a list of address 2000 clients and i want to sort an area name. please help me.
• To post as a guest, your comment is unpublished.
  Hi, I have been looking for this solution for ages. Thank you!! However I have discovered another issue. I have data within the address column that doesn't have a street number associated with it.
  Example
  Anns Road SHEFFIELD South Yorkshire S2 3DJ
  becomes
  Road SHEFFIELD South Yorkshire S2 3DJ
  Is there a solution??