+ Reply to Thread
Results 1 to 2 of 2

Help with merging columns in a specific format

  1. #1
    Registered User
    Join Date
    02-07-2012
    Location
    Boston
    MS-Off Ver
    Excel 2004
    Posts
    8

    Question Help with merging columns in a specific format

    Hi, I have a project in my hands I don't know where to start to automate it (I don't have time to do it manually). I'm using Excel 2004, in a Mac.

    I have a spreadsheet exported from our database with a few columns for a few thousand individual records. Each individual record (a row) includes columns for "First Name", "Last Name", "Title" and "Phone Number". I need an automated way to reformat those 4 columns (either on that existing spreadsheet or into a separate spreadsheet) so they are merged into a single column in this exact format: {First Name Last Name, Title.....Phone Number; } (minus the {}'s) What is the best way to go about doing this? Thank you!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,724

    Re: Help with merging columns in a specific format

    Put this in the first empty cell next to your data (E1 ??):

    =A1&" "&B1&", "&C1&"......"&D1

    Then copy down by double-clicking the fill icon (the small black square in the bottom right corner of the cursor).

    Hope this helps.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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