• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Get Array Length...

Aysher Ryan

New Member
I have following text, in Excel in D5 Cell

VB933 + VB19 + BB3

I am not able to get the length of Array; for example, I should get 3 on the sample text for VB933, VB19 & BB3
Not able to get the length of the array using Array.Length; can someone please help!

Peter Bartholomew

Well-Known Member
I don't see anything that looks like an array.
It looks more like an 18 character string to me. It could be treated as a formula, in which case it would evaluate to give a single number.