Results 1 to 23 of 23

Excel Formatting & Capabilities Question

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2016
    Location
    Las Vegas, Nevada
    MS-Off Ver
    2013
    Posts
    6

    Question Excel Formatting & Capabilities Question

    (NEWBIE)

    I have a mailing list I put together of the last several months; over 2000+ Name and Addresses. How do I configure my list in a fast/quick/easy way in to the right format using Excel or some other type of computer software? I need for this same list to be corrected/modified by adding the necessary commas within the right areas for importing into a Mailing Software. Would I have to manually add the commas (comma delimited) in the right areas one-by-one using Excel or is there a software out their - that will do that for me fast and automatically (so-to-speak)?

    EXAMPLE OF THE CORRECT FORMAT I AM LOOKING FOR: ABC Company, 1234 Jones Blvd, Las Vegas, Nevada, 89119, abc@yet.net

    REQUIREMENT: I need six fields/grids: Company, Street/Mail Address, City, State, Zip-code and Email Address – ALL separated properly with a comma in the right areas.

    Here is a sample of my list (Names & Addresses Have Been Modified For Privacy Issues):

    ABC Fraternity - 1160 Peachtree Street, NW, Suite: 1604, Atlanta, Georgia 30303
    Good Day - 2003 Saint Paul Street, Baltimore, MD 21218 - support@apa1123.net
    Westgate Services, 2311-24 North Broad Street, Philadelphia, PA 19132-4590 - info@kappaaweqsi1911.com
    Omega Fraternity, Inc. - 3221 Snapfinger Parkway, Decatur, Georgia 30035 - info@osdpf.org
    Walstore Inc. - 105 Kennedy Street, NW Washington, DC 20011-5294 - info@ibfghsigma1914.org
    Sigma, Inc - 7022 Commerce Street, Suite 620, Dallas, Texas 75202
    Cookie - Founders Hall, 1600 N. Calvert Street, Baltimore, MD 21202 – grandpo234@iotaphitheta.org, grandvice567@iotaphitheta.org
    Last edited by acvegas; 01-13-2016 at 04:36 PM. Reason: Recommended by Moderator

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Put a comma before three digit if comma is missing
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-01-2016, 01:01 PM
  2. Put a comma before three digit if comma is missing
    By sroysroy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2015, 12:06 PM
  3. Comma delimited numbers with space after comma
    By Cicada in forum Excel General
    Replies: 5
    Last Post: 04-23-2015, 09:32 AM
  4. [SOLVED] Code to Replace Comma with dot and dot with comma
    By BS Singh in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2014, 06:10 PM
  5. Find and remove all text to the left of last comma (including comma) in a cell
    By Excelrookie_1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2013, 08:47 AM
  6. [SOLVED] If comma present, then place a character before and after comma (FORMULA)
    By jaimealvarez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2012, 04:04 PM
  7. replace the comma separator to a dot and dot to a comma at the same time
    By barkiny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-24-2010, 05:42 PM

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