| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering on upper/lowercase letters | Excel Worksheet Functions | |||
| In Excel, can you change uppercase letters to lowercase | New Users to Excel | |||
| Use Go to function to identify dependent cells between worksheets | Excel Worksheet Functions | |||
| change capitalize letters to lowercase | Excel Discussion (Misc queries) | |||
| capital letters to lowercase | Excel Discussion (Misc queries) | |||
Linear Mode
