| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert data with length between 11 OR 15 digits
Hi,
I want to create the formula than can calculate the Length of cell is 11 or 15 dig (in one formula only), and the blank cell (null) is doesn't count for. I preffered the formula to be inserted ini Conditional Formula, and if there's any cell that contain data not 11 or 15 dig, it's cell gonna have a red background (ps. the blank cell also not to be count, cause I want to copy to single coloumn) If anyone could help me on this formula, before thank you first to you. Thanx. Nico. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| character length in data forms | Excel Discussion (Misc queries) | |||
| copy, insert and add digits | Excel Worksheet Functions | |||
| Need insert a dash in between last 4 digits in text string | Excel Worksheet Functions | |||
| Graph with variable data length | Excel Discussion (Misc queries) | |||
| length of character data | Excel Discussion (Misc queries) | |||
Threaded Mode
