Calculations with text

[Mike G]

I've got a sheet with 4500 text entries in one column which are in the
following format

AAABB, AAABC, BBBDD, BBBEE where the first three letters are for location
and the last two are for department. There is no separator.

What I need to with these is:

1. Count entries by department (last two letters)
2. Count entries by location (first three letters)
3. Find and extract records to a separate worksheet within the workbook.
That is find all records of location AAA and copy to sheet 4 or find all
records with department BB and copy to separate sheet.

Can Excel manipulate text this way?

 

[J.E. McGimpsey]

One way:

1) =COUNTIF(A:A,"*BB")
2) =COUNTIF(A:A,"AAA*")

3) Look at Advanced Filter in XL HELP.