| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Len function returns bigger number
I import PipeID from an engineering software about pipe analysis (EPNET).
and put them in column A:A, like A1:KP51. When I perform LEN functionin this cell, LEN(A1), it returns 17. I suppose it should return 4 I cant understand why. I have these pipID (like KP51) made by excel as well. When I want to perform countif, on these PipeID's, it doesn't work. I think I have to change the format of this column -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| Force function to show positive or negative number? | Excel Worksheet Functions | |||
| Function that Returns address of that cell? | Excel Worksheet Functions | |||
| PERMUT function | Excel Worksheet Functions | |||
Threaded Mode
