Extract UPPER CASE words.

i had a scenario in which i need to extract only the UPPER case words from a column and paste them in the adjacent column. Is there any formula or vba routine for it.

Ex:
COL A contains the following:
FIRST
second
THIRD
FOURTH
fifth
sixth
SEVENTH

......and so on.

i need to extract only the Letters or words which are in total Uppercase and paste them in the next column ..i.e. COLUMN B..

any forumlas...

Based on your example:

Please Login or Register  to view this content.

Try using an Advanced Filter...

Using your posted data in A2:A8

Please Login or Register  to view this content.

Notice that we are referencing the first data row...not the heading

Please Login or Register  to view this content.

The Advanced Filter will list all records that test TRUE for all upper case under cell B1.

Is that something you can work with?

i was very near to the solution.i used exact & upper functions also.but i think i messed up in using the right function at the right place.any ways,thanks for the solutions ...