| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find a character to sort on in an Excel cell if not the 1st charac
My Excel files contain identifying words or symbols in a column. How can I
sort to bring the desired rows to the top if the charcater or word is not the first one on the cell? I use Microsoft Office 2003 on XP. |
|
#2
|
|||
|
|||
|
Find a character to sort on in an Excel cell if not the 1st charac
Use a helper column of formulas that look for your words or symbols, and
then sort both columns based on the results of the formula. HTH, Bernie MS Excel MVP "drrons" wrote in message ... My Excel files contain identifying words or symbols in a column. How can I sort to bring the desired rows to the top if the charcater or word is not the first one on the cell? I use Microsoft Office 2003 on XP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I increase the character capcity of an Excel cell? | Excel Discussion (Misc queries) | |||
| VBA, Excel - Find Range, Sort | Excel Worksheet Functions | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
Linear Mode
