• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by ButchJ

  1. B

    Save CSV without headers

    Hui, Great! With these two changes, the issue is solved. For i = 2 To rng.Rows.count Print #1, Mid$(txt, 3) Now every time the csv file is saved, the formatting is exactly what I need. The best part is now I don't have to deal with the character count in the header row. Thanks for your...
  2. B

    Save CSV without headers

    How can I save a csv file without the top header row? I have a spreadsheet with up to 14 columns of data: The column headers are: Name Addr Phon (for the first three columns now in use) Total character count for row one is 12, that is A1, B1 & C1 all have 4 characters each. I have a button...
  3. B

    Phone Number formatting

    Thanks Hui, That will work.
  4. B

    Phone Number formatting

    Hi, I’m trying to format phone numbers from this column A format: 123-123-1234 or (123) 12301234 to this column B format: (123) 123-1234 (Column A can have two formats) (Column B can have only one format) If a cell in column A is empty, the adjacent cell in column B should also be empty...
See more
Back
Top