ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to detect 5th character? (https://www.excelbanter.com/excel-discussion-misc-queries/52945-how-detect-5th-character.html)

nastech
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

Gary''s Student
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

Roger Govier
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

nastech
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

nastech
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


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com