Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Change Delimiter For Csv Export - Tip

  1. #1
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035

    Change Delimiter For Csv Export - Tip

    Haven't had occassion to use this, but a colleague passed it on and it looks useful. (Couldn't find it referenced here on Oz.)

    If you need Export Excel data to a CSV file but the data have commas in it, you can in Windows change the delimiter used in the export from outside of Excel -- specifally via the Control Panel.

    Go to the Control Panel --> Regional and Language Options (or Date, Time and Regional Options --> Regional and Language Option on some machines) --> click the Customize button. In the dialog box that opens you will see and option for "List separator" in which you can change the comma to a different character --> click Apply then Ok and then Apply again. Now when you go into Excel and choose Export as CSV the new character will be used as the delimiter.
    Best Regards,
    Tom
    ---------------------------
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,364

    Re: Change Delimiter For Csv Export - Tip

    Hi Tom,

    Thanks for the tip. I think it should be in Hey! That's cool section.

  3. #3
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,717

  4. #4
    Join Date
    22nd April 2003
    Location
    Virginia, USA
    Posts
    5,035

    Re: Change Delimiter For Csv Export - Tip

    One would think I'd know where (and where not) to stick my nose (posts) by now.
    Best Regards,
    Tom
    ---------------------------
    Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Export To Text File With Specified Delimiter
    By thedvirs in forum EXCEL HELP
    Replies: 2
    Last Post: September 11th, 2007, 17:07
  2. Replies: 5
    Last Post: September 23rd, 2005, 00:30
  3. = delimiter
    By wdale in forum EXCEL HELP
    Replies: 3
    Last Post: February 10th, 2005, 23:46
  4. Change row color on Excel export
    By beveritt in forum EXCEL HELP
    Replies: 4
    Last Post: November 23rd, 2004, 03:24

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
  •  
porno