sorting

  • Thread starter Thread starter LMO
  • Start date Start date
L

LMO

Does any one know how to take a column in a worksheet that has several words
in it and sort them by a specific word?

eg; M Walter c/o ABC
I dont know
please help c/o ABC

I want all of the ABC to appear together
 
An easier thing to do would be to find "ABC" anywhere in the string and
place it in another column then you can sort the columns on that.

=FIND("ABC",B4,1)
 

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

unique values among duplicates without considering specific words 1
Scrabble Value calculation for Welsh words 0
search and copy text from one sheet to others 4
I Need Help with COUNTA and/or SUMPRODUCT 3
worksheet sorting and linking? 0
return unique data from a list 4
sorting array formula 2
Conditional formatting 3

Back
Top