Help! I imported a list of addresses from Google Maps. The column containing street address also contains distance separated by a vertical line, ex. (526 Main Road | 33m), the last portion of which I need to eliminate. The list is very long. The text to columns function does not seem to be a solution. Would a macro work for this?