[SOLVED] Function to Get Array Count from Cell Reference and Repeat

I couldn't figure out a better way to titled it :\ Basically I'm trying to create a function that has three parameters -- the cell you want to reference, the delimiter in the reference cell, and the string you want repeated.

For example in my first cell (A1 for example) I have:

Strawberry,Kiwi,Orange,Mango,Papaya

In the adjacent cell (B1 for example) I would type my function =Example(A1,",",'Fruit") and that would return

Fruit,Fruit,Fruit,Fruit,Fruit.

Can I create an array by using Split, looping on that array, and then joining them back?

Hi desertshore,

Find attached what I think you want. It has a UDF called Example that takes 3 arguments like you suggest.

Function looks like this:

Please Login or Register  to view this content.