+ Reply to Thread
Results 1 to 5 of 5

Reformat & Add Commas

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    Washington, DC
    MS-Off Ver
    2013
    Posts
    5

    Question Reformat & Add Commas

    Hi,

    This may be a simple question & simpler solution...

    I have over a 100 lines of ID's in Excel and I saved it as a CSV however, when I open the file it still basically looks the same:

    123
    1223
    100455 etc.

    I want it to look like:

    123,1223,100455,etc.

    Is there a way to convert it to this format?

    Thanks,

    DJ

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Reformat & Add Commas

    =a1&&","&a2&","&a3 etc
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    Washington, DC
    MS-Off Ver
    2013
    Posts
    5

    Re: Reformat & Add Commas

    I'm even more confused now

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Reformat & Add Commas

    You gave 3 cells, which i added together in 1 cell.

    you have 7 in your reply.

    I don't see how the 3 cells are related to the 7

  5. #5
    Registered User
    Join Date
    08-07-2014
    Location
    Washington, DC
    MS-Off Ver
    2013
    Posts
    5

    Re: Reformat & Add Commas

    Sorry, I was just indicating I was really confused ... not relating to your answer on the reformatting.

    Now I think I understand ... Let me play around with it for a while.

    Thanks,

    DJ

+ 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. reformat VBA
    By cmccabe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2014, 10:40 AM
  2. Replies: 5
    Last Post: 01-17-2014, 05:56 PM
  3. Cannot reformat cells
    By Suzanne53 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-11-2013, 04:30 PM
  4. [SOLVED] Reformat Macro
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2012, 12:19 PM
  5. going to reformat data
    By 00Able in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-07-2011, 07:02 PM

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