Hi there, may excel column A, B, C etc always starting at the rigt side corner and the Sheet 1,2,3 also is in the oposite.. how will i return then to a normal way reading the column A-Z, left to right. please email me your answer at email@example.com. thanks a lot. God bless to all, more power guys
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
Or: XLSX Repair Kit. The latest corrupt XLSX file repair software featuring a powerful data recovery core and a convenient step-by-step wizard for extra convenience.
For more information: http://www.xlsx.repair/
Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".
If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.
Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.
Then finally, export/save as that external sheet to any filename of your choice.
I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).
Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.
Now click back to Sheet1 where your data is and in A2 put this formula: =VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE) Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.
You can copy and paste this formula down the column to calculate your other values.