Need MS excel IF formula

[capronton]

IF textString is 4 characters then i want first two characters, else first character.

Example below:

505 5
1305 13

I'm working with the formula below. Can someone tell me what is wrong with this formula? I know this is not an excel formula, but thought I would ask.

=IF (LEN(A1,4),LEFT(C2388,2,LEFT(C2388,1))

Thanks.

 

[capronton]

Formula should be:

=IF (LEN(A1,4),(LEFT(A1,2),(LEFT(A1,1))

 

[AndyMc]

If len({textString}) = 4 then left({textString},2) else left({textString},1)

 

[SkipVought]

The Excel formula is


=IF (LEN(A1)=4,LEFT(A1,2),LEFT(A1,1))

assuming your value is in A1.

 

[capronton]

Thank you both, this was very helpful.

 

[SkipVought]

Best to post Excel questions in forum68.