View Full Version : Excel Array formula

01-09-2016, 10:17 AM
Hi, first post hopfully its ok here.

I have a excel formula that I want to put into an array to copy down all rows. Formula is =if(iserror(split(AN2,",")),"",split(AN2,","))

Any help is great as I can not get an arrayformula to work.


01-09-2016, 10:31 AM
1. I think that you could just fill down regular formulas if you wanted to

2. If you want to use an array formula, then click the formula cell, high light where it goes, and then control-shift-enter, which will add { } around the formula

Bob Phillips
01-09-2016, 10:54 AM
Is Split a UDF? Does it break the cell out into multiple cells, vertically or horizontally?