Identify Lowercase Letters in Cells Using Function
 

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

Identify Lowercase Letters in Cells Using Function
 

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
---------------
Jacob Skaria


"TGV" wrote:

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

Identify Lowercase Letters in Cells Using Function
 

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

Identify Lowercase Letters in Cells Using Function
 

Thank you its working fine.

--
If this post helps, pls click Yes
---------------
TGV


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"TGV" wrote:

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

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