| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find max number of character and return cell address
A simple way to see how many "?" are in each cell, enter this formula in F18 & copy down: =LEN(E18)-LEN(SUBSTITUTE(E18,"?","")) This will let you sort them and see the duplicates -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=533076 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
| Finding a character type within a cell | Excel Worksheet Functions | |||
| FIND a character | Excel Discussion (Misc queries) | |||
| identify data in a cell that has a number as the second character | Excel Worksheet Functions | |||
Threaded Mode
