Large data base with Addresses that need correction

**pick44** · 02-15-2019, 04:41 PM

This is sample of what I have to change.
This To this
600 W ELMS RD: @SAM'S DOLLHOUSE CLUB 600 W ELMS RD
600 E CENTRAL TEXAS EXPY: @ECONO LODGE 600 E CENTRAL TEXAS EXPY
5000 S FORT HOOD ST: @NOCKED AND LOADED 5000 S FORT HOOD ST
3100 E STAN SCHLUETER LOOP: ALIAS 3107 E SSL::@DOLLAR GENERAL 3100 E STAN SCHLUETER LOOP
2900 ZEPHER RD #2006 KILLEEN 2900 ZEPHER RD

The addresses need to have an address with like the "To this" example on the upper right.

Windows 10, Excel 2016

**alansidman** · 02-15-2019, 06:09 PM

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Large data base with Addresses that need correction

LinkBack

Thread Tools

Rate This Thread

Display

Large data base with Addresses that need correction

Re: Large data base with Addresses that need correction

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Large data base that needs some cells filled in...see attachment

Large data sheet, searching for addresses, Macro

Large Data Base-Need to Pull Some Address Ranges From Data

[SOLVED] Very large data base and need to separate address from street name

[SOLVED] Find or Match and Replace-large data base

Need to pull address ranges with accompanying data for large data base

[SOLVED] Want to separate unique and duplicate data from large data base

Bookmarks

Bookmarks

Posting Permissions