Windows 10: MS Excel - Sorting text cells
Discus and support MS Excel - Sorting text cells in Microsoft Office and 365 to solve the problem; I am entering stamp collection catalogue "numbers" in a spreadsheet column. However, I am having problems sorting the stamps properly. For example:... Discussion in 'Microsoft Office and 365' started by Tony Vella, Sep 1, 2017.
Thema:
MS Excel - Sorting text cells
Loading...
-
MS Excel - Sorting text cells - Similar Threads - Excel Sorting text
-
Number problem in Excel cell
in Windows 10 GamingNumber problem in Excel cell: When, I enter a number in one cell,then I enter into another cell.On that time the first cell number become into decimal.example likeex.in Frist cell I enter 25 then I changed cell second one,but the first one became 0.25 like this ,what can I do now ,i think any settings... -
Number problem in Excel cell
in Windows 10 Software and AppsNumber problem in Excel cell: When, I enter a number in one cell,then I enter into another cell.On that time the first cell number become into decimal.example likeex.in Frist cell I enter 25 then I changed cell second one,but the first one became 0.25 like this ,what can I do now ,i think any settings... -
Cannot select text in one specific cell in Excel 365
in Windows 10 CustomizationCannot select text in one specific cell in Excel 365: Am trying to select text in a cell in Excel365 to change it to strikethru but cannot select it by any means - double click just moves the cursor - SHIFT Arrow left/right does the same. I can delete it, but not select it. Other cells work correctly. Any ideas?... -
Cell formulas in excel spreadsheets
in Windows 10 CustomizationCell formulas in excel spreadsheets: Can someone help me to I presume clear formatting in cells. I'm entering a column of numbers in this case planting space guides for vegetables and every once in awhile a random cell will revert to a date. For example, if you look down the column you see 15-30, 40-50, Oct-15... -
Excel sorting
in Windows 10 Network and SharingExcel sorting: I want to sort a column of data, all of it starts with text then a number, so candidate 1; candidates 2 etc. when this gets up to candidate 10 & 11 etc and i sort the list it comes out as candidate 1; candidate 10, candidate 11, candidate 2; candidate 3 etc, i know its... -
How To Sort Microsoft Excel Cells Alphanumerically?
in Microsoft Office and 365How To Sort Microsoft Excel Cells Alphanumerically?: Hello all, Long time no see. Been gone for a while, but now I need some help Let's say that I have an Excel table: Name Marge Maggie Lisa Homer Bart How can I sort the column so that it results in: Name Bart Homer Lisa Maggie Marge I've found some tutorials elsewhere,... -
coping text from a excel cell to another excel cell
in Windows 10 Network and Sharingcoping text from a excel cell to another excel cell: I am trying to copy text from one excel to another excel cell automatically on the same worksheet https://answers.microsoft.com/en-us/windows/forum/all/coping-text-from-a-excel-cell-to-another-excel/5a272c74-33e6-457c-82f8-3ae3196e8f81" -
Make Excel display text in a column's cells based on the presence of text in neighboring cells
in Windows 10 Network and SharingMake Excel display text in a column's cells based on the presence of text in neighboring cells: 1-21-19 I have seen some discussions relating to this question that involve formulae that result in text appearing in a column's cells based on the findings of a numerical value in a neighboring cell, or the converse-- a numerical value is made to appear based on a formula... -
EXCEL sort sequence
in Microsoft Office and 365EXCEL sort sequence: Hi there I'm trying to create a list of Movies in my DB in alphabetical order with folders A,B,C etc. Is there a way to store for example "The Day the earth Stood Still - 1951" in D ignoring the word "THE" in the sort sequence if it's the first word of the film title. I...