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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. EBenoit84

    Excel Macro

    It is to an extent, but a macro would be better because there is no telling how much data might be in the spreadsheets. Even a macro for a delete shift left would work just fine.
  2. EBenoit84

    Excel Macro

    Hello, I am looking for an Excel 2003 macro that will merge any column that has a header (starting at B1:Last column with a header), trim and intrim (to remove the blanks), then do like a text to column split on the ' ' (space). Example: A B C D E A C E...
  3. EBenoit84

    Excel Macro

    Hello, I am looking for an Excel 2003 macro that will concatenate 'X' number of columns together (starting at column 'B', trim and intrim (to remove the blanks), then do like a text to column split on the ' ' (space). Even if the text to column split part is done in a seperate macro, that...
  4. EBenoit84

    MS Access 2003

    Thanks for the help. Pwise - Do you know of a way to concatenate the fields without referencing the headers to do it. I want to get rid of the year that shows up blank for certain parcels: 175-H-323 [blank] [blank] [blank] [blank] 2007 2008 175-H-325 2003 2004 [blank] [blank]...
  5. EBenoit84

    MS Access 2003

    Hello, I have two columns, Parcel and Year, the parcels have duplicated numbers corresponding to a different year: Parcel Year 175-H-323 2007 175-H-323 2008 175-H-325 2003 175-H-325 2004 I am wondering if it is possible to check the parcel descending and for those that...
  6. EBenoit84

    MS Access 2003

    Hello, I have two columns, Parcel and Year, the parcels have duplicated numbers corresponding to a different year: Parcel Year 175-H-323 2007 175-H-323 2008 175-H-325 2003 175-H-325 2004 I am wondering if it is possible to check the parcel descending and for those that are the same...

Part and Inventory Search

Back
Top