| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how to detect 5th character?
Is there a way to tell if there is a 5th characater in a cell, instead of 4?
Thanks - Nastech |
|
#2
|
|||
|
|||
|
how to detect 5th character?
Use the LEN() function.
-- Gary''s Student "nastech" wrote: Is there a way to tell if there is a 5th characater in a cell, instead of 4? Thanks - Nastech |
|
#3
|
|||
|
|||
|
how to detect 5th character?
Hi
Try =IF(LEN(A1)=5,"5th character","No 5th character") Regards Roger Govier nastech wrote: Is there a way to tell if there is a 5th characater in a cell, instead of 4? Thanks - Nastech |
|
#4
|
|||
|
|||
|
how to detect 5th character?
thankyou very much.. -nastech
"Roger Govier" wrote: Hi Try =IF(LEN(A1)=5,"5th character","No 5th character") Regards Roger Govier nastech wrote: Is there a way to tell if there is a 5th characater in a cell, instead of 4? Thanks - Nastech |
|
#5
|
|||
|
|||
|
how to detect 5th character?
thankyou very much.. -nastech
"Gary''s Student" wrote: Use the LEN() function. -- Gary''s Student "nastech" wrote: Is there a way to tell if there is a 5th characater in a cell, instead of 4? Thanks - Nastech |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
| install Office Assistant character file? | Excel Discussion (Misc queries) | |||
| Copy a column in worksheet with a character change | Excel Worksheet Functions | |||
| Searching a cell for a certain character. | Excel Worksheet Functions | |||
| Removing ' character from cells | Excel Discussion (Misc queries) | |||
Linear Mode
