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 I just go if(len(b3)=5,concatenate("CB0010",b3),"") then it works
fine but above formula returns 0

can anyone help?

thank you