Hi there people
I have a csv file with some stats in , seperated by a semi-colon (;) . When I open the file , it opens directly to Excel but all in one column. Is there any way to get Excel to give me the option to open it as delimited ?
Urgently need assistance please.
Thank you
Rudils,
The key is to import the data and not open the file directly.
1. Open a Blank Workbook in Excel.
2. Data, Get External Data, Import Data. (Excel 2007 is Data, Get External Data, Data from Text)
3. Browse to your .csv file and Select "Import".
4. Import Wizard should appear.
5. Page 1 Select "Delimited"
6. Select the row which you want to start the import.
7. click "Next"
8. In the Delimiters, select "semicolon" and/or other delimiters you are using.
Note: The bottom half of the window will preview the way the data is to be imported.
9. click "Next"
10. highlight each column of your data in the window below. For each column you can specify "General", "Text", "Data", or "do not import column" using the radio buttons in the top left of the Wizard box. This is an optional step.
11. Click Finish.
I hope that helps. Please add a comment if it not clear.
kpenguin
Posted on Nov 22, 2007
How to get figures in the Indian rupee format
Rupees with Paise
[>9999999]"Rs. "##\,##\,##\,##0.00;[>99999]"Rs. "##\,##\,##0.00;"Rs.
"##,##0.00
Rupees without Paise
[>9999999]"Rs. "##\,##\,##\,##0;[>99999]"Rs."##\,##\,##0;"Rs. "##,##0
Rupees without Rs. notation
[>9999999]##\,##\,##\,##0.00;[>99999]##\,##\,##0.00;##,##0.00
Posted on May 14, 2009
i have no idea to slect all sales entry in tally 9
Select all sales entry one by one by pressing space bar, & after selecting all the entries. Siply press Alt+D. all the selected Entries Deleted at once.
Note:- This feature is available on in original Tally Users not for Crecked Tally.
Sachin Sharma
Axis Convergence Pvt Ltd
Noida
Posted on Sep 04, 2009
a friend of mine has an excel file that opens in read only mode, what does he change to be able to open the file in edit mode?
Hello,
There could be 1 of 3 things affecting this:
1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it.
2. Is the file currently in a location that you do not have write permissions? eg. another users shared documents
3. Check in the properties to see if it is set to read only. (right click on the document and click properties. in the 'General' Tab see if 'Read Only' is checked. If yes, uncheck it and click okay)
An easy way to make it editable providing you are the only one using it (If the above fixes dont work) open it up in excel and then click File --> Save As... and then save it somewhere else. That will then make it editable for you.
Have a Great Day!
Posted on Jan 28, 2009
When I open microsoft excel, running in windows xp on a pc, the cursor is stuck in the cell it happens to be in when the spreadsheet is opened. If the mouse is moved, without holding down either button, whatever area it passes over is highlighted, as if the left mouse button were pressed.
Tools menu.
Options.
Edit tab.
Enable the check boxes for "Edit directly in cell" and "Allow cell drag and drop"
OK.
This might have happened if you had opened up a excel with macros enabled!
Posted on Jun 20, 2009
have being facing problems using vlookup in openoffice while using different sheets. am looking for sample solution
=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)
The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula
Posted on May 12, 2009
How to open an excel file that contain a circular reference. When I open it, it show a warning excel security. There's an option disable and enable...What should I do?? Need ur help A.S.A.P...Thanx b4
Posted on Nov 05, 2008
Excel creates temp files when I open a document but then doesn't delete them after closing the file. HELP! Thanks. Running XP btw.
I just finished with Trend Micro help support and they solved this problem for me. Open the main console for Trend Micro. Click on Viruses & Spyware Controls. Click on the "settings" for Protection Against Viruses & Spyware. Click on Advanced Settings. Under the section for "What Should TMIS Check for Threats" click on the circle for "Specify Targets that you choose". Click on "Select" next to "Ignore Specific Files & Folders". Then Add and folders of files that you do not want Trend Micro to check and make backups for. That solved my issue...hope it helps you too.
Posted on Feb 05, 2009
"Not enough memory to run Microsoft excel. Please close other applications and try again." is the error message when I try to open Excel. System has enough Free storage capacity. I tried after closing all other applications... still no use. Also tried renaming the msohelp.exe with .old extension. Could not find Mso9intl.dll and Msoffice.exefiles to rename with.old extension.
Tried reinstalling, uninstalling and repairing Office XP yet issue persists.
Please help on this issue.
it is conflicy with win xp updates.
check your ram.
go to device amanger then advanceced increase your virual memory to 1.5 *your rammmeory.
Posted on Jan 03, 2009
Can anyone of you excel vba wiz and gurus tell me what's wrong with this code, I keep getting a Run-Time error '13': Type Mismatch error with this code.
Private Sub CommandButton1_Click()
Sheets("summary").Range("g74").Activate
Dim i As Integer
i = 74
For i = 74 To 80
ActiveCell.Offset(0, 1).Value = WorksheetFunction. _
SumProduct(--Sheets("stock card").Range("a2:a3351").Value = Sheets("summary").Range("a" & i).Value, _
--Sheets("stock card").Range("b2:b3351").Value = "", _
--Sheets("stock card").Range("e2:e3351").Value >= Sheets("summary").Range("$g$84").Value, _
Sheets("stock card").Range("k2:k3351").Value)
ActiveCell.Offset(1, 0).Activate
Next i
End Sub
Also, I would like to be able to use the "conditional sumif" function using multiple criteria arrays in lieu of the above "sumproduct" function...is this possible???
Thanks in advance, any help is most appreciated...
Jay
i'll just reply to your conditional sumif query.
yes, you can do multiple criteria query but with a matrix formula. you may look it up. nonetheless, here is how one would look like:
{=sum(if(range1=A x range2=B x range3=C, sum range))} note that x (multiplication) is used to denote intersection of the criteria
initially, you'll enter it as:
=sum(if(range1=A x range2=B x range3=C, sum range))
then, edit the cell (F2) and press ctrl+shift+enter for the brackets { } to appear.
Posted on Nov 18, 2008
670 questions posted
Usually answered in minutes!
43 Questions
22 Questions
12 Questions
2 Questions