LEN Problem

Giganews Newsgroups
Subject: LEN Problem
Posted by:  James8309 (jaedong12…@gmail.com)
Date: Wed, 9 Jul 2008

Hi everyone

I have different digit of numbers in column B and I am trying to use
"if" and " concatenate" statement together but it creates an error.

=IF(LEN(B3)=5,CONCATENATE("CB0010",B3),IF(LEN(B3)=4,CONCATENATE("CB00100",B3),IF(LEN(B3)=3,CONCATENATE("CB001000",B3),"")))

if I just go if(len(b3)=5,concatenate("CB0010",b3),"") then it works
fine but above formula returns 0

can anyone help?

thank you

regards,

James

Replies