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

    pgmr80 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:
  • Save an Excel Add-in to a network drive

    I have a MSExcel 2010 workbook which uses a User Defined Function via an Add-in (.xlam file). Although the add-in is saved on a network drive, when I try to load it into my add-in list using the browse in the Add-in Manager, it prompts to copy the add-in to the default path on my harddrive:...

    CBURS5 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