Identify Lowercase Letters in Cells Using Function
Thank you its working fine.
TGV
"Per Jessen" wrote:
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
"TGV" skrev i meddelelsen
...
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
|