address expansion

  1. D

    How do I parse a cell that contains the company name and address.

    How do I parse a cell that contains the company name and address? The previous cell has the company name if that helps? <tbody> Customer Ship to 100% KIDS 100% KIDS 485 CENTRAL AVE CEDARHURST, NY 11516 24 HOUR FITNESS UPS-SCS: 24 HOUR FITNESS 11991 LANDON DR MIRA LOMA, CA 91752 2 HOT...
  2. P

    Expanding address information

    Hi, I am looking for an automatic solution to a problem I am having where i ahve several columns with address range information in, and I need to expand each row into the individual address components. For example.. 1 A 4 B London Road Each component of the first line is in its own cell...

Some videos you may like

This Week's Hot Topics

Top