an
groups-icon

CSV Export/Import Tip

Forum Home / Directory Theme
Wait a minute... This content is very very old. We no longer sell or support this theme version. New Topics
  • Version 9
    user
    Frank Surget
    0 points
    Beginner

    =CONCATENATE(AD2, “, “, AE2, ” “, AI2, ” “, AJ2, ” “, AF2)

    For anyone using the CSV Export/Import function to mass edit your listings in Excel, here’s the formula to concatenate your fields. Just replace your fields in the formula for “map-location” as follows:

    AD2 – map-address
    AE2 – map-city
    AI2 – map-state
    AJ2 – map-zip
    AF2 – map-country

    This will create your “map-location” field with commas and spaces like this:

    3294 Pine Island Rd, Cape Coral FL 33993 United States

    Enjoy!

    Frank

    March 31, 2014 at 5:18 pm
  • user
    Malgorzata Szalata
    0 points
    Beginner
    Members Only Content

    This reply is for PremiumPress customers only.

    Login Now
    March 31, 2014 at 5:55 pm

541

Views

1

Replies

Discussion Groups
New Topics