Identify Lowercase Letters in Cells Using Function

T

TGV

Hi,

I am having data in A column now i want to take the lower case cells
seperately, please guide how i can do this.

ASD
ASDASDF
SDF
ASDF
ASDFDF
SDF
asdaasdf
asdsdf
asdfasdf
ASDFDF
SDF
asdaasdf
ASDASDF
SDF

Thanks in Advance

TGV
 
J

Jacob Skaria

With your data in Column A starting from A1; try the below formula in cell B1
and copy down as required.

=IF(EXACT(A1,LOWER(A1)),A1,"")

If this post helps click Yes
 
P

Per Jessen

Hi

Use an unused column as helper column and enter this formula, and copy it
down:

=EXACT(A1,LOWER(A1))

Select both columns and sort by the helper column.

Hopes this helps.
....
Per
 
T

TGV

Thank you its working fine.

TGV


Per Jessen said:
Hi

Use an unused column as helper column and enter this formula, and copy it
down:

=EXACT(A1,LOWER(A1))

Select both columns and sort by the helper column.

Hopes this helps.
....
Per
Click to expand...
 

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

How to create a report for selected values in the column 0
Comparing two worksheets 2
How to remove dashes "-" from the data in a table column in ms-access 8
Find Special Characters Using Function 4
Small Query - Urgent 2
In search of VBA script 0
Conditional formatting help needed 10
Very Urgent - Find / Search Help Needed 8

Top