1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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

    Hui...

  3. 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...

Discussion in 'Ask an Excel Question' started by Aysher Ryan, Sep 14, 2018.

  1. Aysher Ryan

    Aysher Ryan New Member

    Messages:
    6
    Hi,
    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!
  2. bosco_yip

    bosco_yip Excel Ninja

    Messages:
    2,008
    To get the length of Array

    1] In D5, enter :

    VB933 + VB19 + BB3

    2] In E5, enter formula :

    =LEN(D5)-LEN(SUBSTITUTE(D5,"+",""))+1

    the result return : 3

    Regards
    Bosco
    Chirag R Raval and Aysher Ryan like this.
  3. Hui

    Hui Excel Ninja Staff Member

    Messages:
    11,639
    Aysher

    If this doesn't help please post a sample file
    Aysher Ryan likes this.
  4. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Messages:
    456
    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.
    Aysher Ryan likes this.
  5. Aysher Ryan

    Aysher Ryan New Member

    Messages:
    6
    Thanks for reply bosco. Its working

Share This Page