• Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • Having trouble creating a Client Access session using VBA \

    We have numerous Excel Based Interface Macros that Create Client Access sessions, but none will work with Excel 2010.

    Allalb5 pointsBadges:
  • If-then looking for any text in a cell

    This is what I'm trying to do: If cell A has any text in it, then look at cell B and populate cell C based on what is found in cell B.  If cell A is empty, do nothing.  Is it possible? L.

    ExcelBeginner15 pointsBadges:
  • Find and Replace

    I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?

    needtobecloned15 pointsBadges:
  • Copy

    Normally when I want to copy a group of cells they become highlighted in blue. One of the sheets in my workbook no longer does this. How do I restore this feature to that worksheet?

    tallpen5 pointsBadges:
  • Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K

    We are running a Data File Transfer from the iSeries to Excel 2010, using the Add In off of Excel for File Transfer From iSeries. We can only download 64K records. How can we get this size limit to be larger? Our iSeries is at V7.1 and our client Access is at V6 and/or V7 for various users. We want...

    pgmr85 pointsBadges:
  • Find and replace formula in Excel

    Hi everybody. I am forex and options trader. Options contracts look like this: 'GOOG 121005C770" or "GOOG 121005P770". I need to have a formula that can lookup the cell and if contains "*******P***" to replace the whole cell with "Put" and if the cell contains "*******C***" to replace the whole...

    Eillimasood10 pointsBadges:
  • copying tables to excel

    How do I copy a table with more than 65000 records into an excel workbook?

    DatamanWarwick5 pointsBadges:
  • adding rounded numbers in Excel

    How do you add rounded numbers and get the addition of the rounded number shown not the actual number   .125 displayed as .13 .125 displayed as .13 .125 displayed as .13 I want to use the auto sum of .13+.13+.13  and have the cell display .39 NOT .38

    Ronda5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following