Feedback by UserVoice

 

Chayse

← Welcome to Excel’s Suggestion Box!

My feedback

  1. I think that arrays should be able to pass in expressions

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Chayse commented  · 

    currently arrays in the format {arg1,arg2,arg3...argN} do not support expressions in the parameters

    Chayse shared this idea  · 

  2. Add a Split dynamic array function

    282 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    30 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Chayse commented  · 

    Trying to upload again

    An error occurred while saving the comment
    Chayse commented  · 

    I have a module that does that, you're welcome to it if you want, the function is:
    SPLITSTRING(array, optional delimiter)

    I built it to utilize the built in VBA function "SPLIT" that apparently is not available as a worksheet function. It's also got a bunch of other stuff I've worked on in there too.

    This is mostly a prototype, but I have worked out most of the bugs I can find.

    I tried to upload it here, but I guess I can't?

Feedback and Knowledge Base

(thinking…)