ExcelBanter - Validation a character in a string

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Validation a character in a string (https://www.excelbanter.com/excel-discussion-misc-queries/245141-validation-character-string.html)

coolmale001

Validation a character in a string

Can any one help me setup a formula for verifying a character in
string with a condition
for eg.
if in cell A2 AACFA4928P and i want to verify is the fourth character
from the left is C or not ?

Per Jessen[_2_]

Validation a character in a string

Hi

Look at this:

=IF(MID(A1,4,1)<"c","Not C","Is C")

Regards,
Per

On 10 Okt., 13:46, coolmale001 wrote:
Can any one help me setup a formula for verifying a character in
string with a condition
for eg.
if in cell A2 AACFA4928P and i want to verify is the fourth character
from the left is C or not ?

All times are GMT +1. The time now is 10:02 PM.