Results 1 to 11 of 11

Separate data in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    Mexico
    MS-Off Ver
    Excel 2007
    Posts
    11

    Separate data in a cell

    "300 Flauger Hill Road - Aberdeen, OH 45101
    "
    This is my cell, I need to separate:

    Street
    City
    State
    Zip

    into separate columns so I can import it into CRM
    I can use the character right left to pull the zip and state because they have the same amount of characters, but it won't work for City and street.

    Please help!
    Last edited by Neilsen69; 09-02-2011 at 01:34 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1