• Excel, Lotus Notes view

    Whenever I export data from view to Excel using the export menu, I choose in the format of comma separated values once exporting is done, I open it in excel with comma separated data as in separate columns, till this everything is fine. Now when I see data in a particular column in excel for eg...

    shivasanjay2,535 pointsBadges:
  • Current column name in Microsoft Excel

    Could someone tell me what the function is to get the current line number / current column name for cells in Microsoft Excel? Thanks!

    ITKE351,965 pointsBadges:
  • SAP ARC service line items export to Excel

    ARC (Annual Rate Contract) service line items with rate export to excel, so what is t-code?

    Pradeep3410 pointsBadges:
  • Excel to tsv

    How do I import excel to tsv format?

    lburks5 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • Zero keeps disappearing in my Excel spreadsheet column

    So I'm adding some of my personal information into an Excel 2007 workbook and I've noticed that when I put in a number count that starts with zero, it automatically disappears. Here's an example: 012345678 changes to 12345678 What do I have to do keep the zero as entered and not disappear.

    ITKE351,965 pointsBadges:
  • Excel.exe process is getting struck in task manager and it’s not closing even the session is end

    Hi, My code is invoking Excel process to generate the report and that is killing once the process is completed. But sometime, couple of Excel.exe process is getting struck even the session is ended. Which is causing NFS memory full. Please advise me of what the the root cause to this issue is. By...

    FIRSTSCHOOL5 pointsBadges:
  • EXCEL 2003 and VLOOKUP help in calculating percentage in third cell

    Hi all, I have three cells in an Excel 2003 worksheet. Cell one is a drop down list containing: 01/07/2009 – 30/06/2010 01/01/2009 – 31/12/2009 Cell 2 is a dollar amount which is manually entered Cell 3 will calculate a dollar percentage of Cell 2 dependent on which date range is chosen in Cell...

    Ianmax4975 pointsBadges:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay I figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s This is what I had: =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • RUNSQLSTM and Excel

    Can an Excel spreadsheet be created with the runsqlstm?

    lewman5 pointsBadges:
  • Can I zoom in on a linear graph in Microsoft Excel?

    I'm looking to create a linear graph in Excel to show the difference between three algorithms. However, the differences are smaller compared to their overall values. Because of this, the lines merge and I can't see the small differences. Is there a way in Excel to zoom in on the linear graph so I...

    ITKE351,965 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger505 pointsBadges:
  • Multi-line text from Microsoft Excel without quotes

    I'm creating a multi-line string in an Excel cell by using "Alt-Enter". If you copy that cell to an text editor, Excel automatically adds double quotes around the full string. Cell1 | Simple String 1 Cell2 | First line of a | Multiline string | with 3 lines Cell3 | Another simple line 2 However,...

    ITKE351,965 pointsBadges:
  • Subtracting cells only if they have a value in Excel

    I want to subtract two cells in excel but only if both cells have a value. For instance, the formula I am using is thus: F2 is currently =E2-D2 but I only want this to be calculated when E2 has a value.

    ITKE351,965 pointsBadges:
  • Oracle Reports 6i – Convert data in Microsoft Excel

    How do I convert Oracle Reports 6i data into a Microsoft Excel through coding on button?

    Sskhan35 pointsBadges:
  • Joining two Excel spreadsheets

    I am looking for a way to join two spreadsheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name and address and an ID column that was pared down by another office.  I...

    ITKE351,965 pointsBadges:
  • Microsoft Excel

    How do you stop Excel from highlighting multiple cells at once when you only click on one? It's really frustrating when doing data entry.

    FHAVEN10 pointsBadges:
  • Is it possible to have Regular Expressions in Excel without VBScript?

    I know this is a longshot I'm looking for a Microsoft Excel function that I could put in a cell to do a "regex" search of content in other cells. I'm looking to stay away from adding VBScript. Is there any other way of doing this?

    ITKE351,965 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