| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
