Find a character to sort on in an Excel cell if not the 1st charac

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells only display a maximum number of text characters 4
Sorting day names chronologically 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
using the =page! feature to transpose a row to column 0
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Sorting on only certain characters in a cell 3
sort not working 3
Sort not saved across saves/reopens 2

Back
Top