Length formula inconsistency

[Ambassador777]

Given:

A1 = KNZY
A2 = NZY

Goal: Append a "K" to the beginning of any cell in Column A:A that contains only three letters.

Test1:
Formula in column B:B =if(len(A1)=3,"K",A1)

Results: A1 = KNZY ; A2 = NZY

Test2:
Formula in column B:B changed to =if(len(A1)=4,"K",A1)

Results: A1 = KKNZY; A2 KNZY

I perplexed why there is no "K" being appended in Test1 results and why there is an extra "K" appended in Test2.

Any help on this is deeply appreciated

 

[Stu Dapples]

=IF(LEN(A12)=3,"K"&A12,A12)

Should sort it.....

 

[Weaver]

=if(LEN(A1)=3,"K","")&A1

 

[jasonb75]

How about

=RIGHT("K"&A1,4)

 

[Ambassador777]

SOLVED: Length formula inconsistency

Perfect! Thanks.

 

[Weaver]

How about

=RIGHT("K"&A1,4)

LOL I thought about that too, but it wasn't 100% certain that 4 characters was the maximum length. Judging from the op's response, that obviously wasn't a problem.