+ Reply to Thread
Results 1 to 4 of 4

Getting info from Excel to be comma delimited with no spaces

Hybrid View

  1. #1
    Registered User
    Join Date
    07-10-2014
    Location
    Noblesville, IN
    MS-Off Ver
    Office 2010
    Posts
    2

    Talking Getting info from Excel to be comma delimited with no spaces

    Hi, I am new here so I apologize for this post if it's already in another thread. I do not work with Excel other than the super simple basic stuff that my 3 year old could probably figure out. However, I have to take info from Excel that is in 4 different columns and put it in our company's eblaster in comma delimited format with 0 spacing between.

    So I need this:

    email@email.com John Public ABC Company (where each piece of information is in column A, B, C & D in Excel respectively)

    to look like this:

    email@email.com,John,Public,ABC Company

    It's ok if there are spaces inbetween the names in the company column, but I can't figure out how to take that information and quickly and easily change it. In the past, I've always done a simple copy/paste from Excel into Notepad, then sat and manually entered commas and deleted the spacing between. That's fine if my list is less than 100, but I have a very large list and don't have the time to manually change it all right now. Here's to hoping there's a fix!

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Getting info from Excel to be comma delimited with no spaces

    Formula: copy to clipboard
    =concatenate(a1,",",b1,",",c1,",",d1)


    in above example output should be
    email@email.com,John,Public,ABC Company
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    07-10-2014
    Location
    Noblesville, IN
    MS-Off Ver
    Office 2010
    Posts
    2

    Re: Getting info from Excel to be comma delimited with no spaces

    Thank you humdingaling, that worked great!

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Getting info from Excel to be comma delimited with no spaces

    sure thing
    not a problem

    Cheers
    Hum

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Merging data vertically in Excel CSV (comma delimited)?
    By SteveJeffs in forum Excel General
    Replies: 4
    Last Post: 05-30-2013, 04:03 AM
  2. savings excel sheets in comma delimited text
    By Aishashk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2013, 08:26 AM
  3. [SOLVED] Pipe delimited vs comma delimited problem
    By theletterh in forum Excel General
    Replies: 4
    Last Post: 01-23-2013, 07:27 PM
  4. Import Comma delimited info in a Column
    By Burger23 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-05-2006, 11:50 PM
  5. [SOLVED] Can an Excel spreadsheet be exported to a comma-delimited import .
    By jdebnam in forum Excel General
    Replies: 1
    Last Post: 04-21-2005, 07:06 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