Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Snookless7

  1. Snookless7

    Excell 2010 - attempting to convert to a comma delimited txt file AND keep my Leading Zeroes.

    I got it......and it was you...your right. I saved as a CSV file but kept opening like an idiot. Instead I selected "open with", note pad...then saved as txt. Worked like a champ! Thank you!
  2. Snookless7

    Excell 2010 - attempting to convert to a comma delimited txt file AND keep my Leading Zeroes.

    yes......CSV (MS-DOS) ..tried all the CSV files though.
  3. Snookless7

    Excell 2010 - attempting to convert to a comma delimited txt file AND keep my Leading Zeroes.

    Does not look like it - txt file - comma delimited - leading zeroes.
  4. Snookless7

    Excell 2010 - attempting to convert to a comma delimited txt file AND keep my Leading Zeroes.

    Thank you skip, however In the end I need and actual txt in notepad file to import into my database. I am a little ignorant with some of this stuff but I do try :-) Todd
  5. Snookless7

    Excell 2010 - attempting to convert to a comma delimited txt file AND keep my Leading Zeroes.

    Hello, Been attempting to export an excel 2010 file to a comma delimited txt file AND keep my Leading Zeroes. But it keeps removing the leading zeroes. The leading zeroes can be dates or a set of numbers. I currently save as CSV file first, then open notepad > file Open > select my CSV file...
  6. Snookless7

    How do I combine Data in Excell

    Well.....I was in a rush with my last reply.. TO dhookom....Thank you very much. Your Solution worked like a champ. Excel has limits as we all know so I could only run 4650 records at a time. Thanks again for your Help.
  7. Snookless7

    How do I combine Data in Excell

    got it......I have to break it up...Marry Me?? LOL Much appreciated.
  8. Snookless7

    How do I combine Data in Excell

    Thank you Dhookom.. I did exactly what you said....for #6 i typed =RangeConcatenate(A1:A39366)......then saved....I got #value" in that cell. Any Ideas. And thanks for the lesson...that was easy.
  9. Snookless7

    How do I combine Data in Excell

    The attached link should workhttp://www.mediafire.com/view/?se0so35nwd83v1e
  10. Snookless7

    How do I combine Data in Excell

    Well the dropbox idea will not work. :-(
  11. Snookless7

    How do I combine Data in Excell

    Well unfortunately my ignorance prohibits me from using that.......LOL That is above my knowledge skill....don't know where to start on that. I put the file in my dropbox....not sure if anyone can get to it. https://www.dropbox.com/home/Zips
  12. Snookless7

    How do I combine Data in Excell

    Hello all- This one I can not figure out... Column A has 1 zip code per row. I have 39K rows. I need to get all of them in one cell separated by a comma. How can this be accomplished. Much appreciated your help is!! Snookless
  13. Snookless7

    Summing specific Words in Crystal

    I got it.....wooohooooo. I used a running total field instead with a small expression. If you know of an easier way...please feel free and share.
  14. Snookless7

    Summing specific Words in Crystal

    Hello- I have a crystal report wherein the report I have groups, each group there is a name and types of issues they have resolved from either Email, Live chat, or Telephone. What i am trying to do per group is to count how many emails they have resolved as well as phone calls and Live...
  15. Snookless7

    Excel 2010 - Can excell do this?

    I got it...was user Error. i forgot to remove the header. Thanks peeps.
See more

Part and Inventory Search

Back
Top