On Feb 13, 4:09*am, Ron Rosenfeld wrote:
In using the ACONCAT function, have you tried it "stand-alone" using just a
simple range as an argument?

I tried entering =aconcat(A1:A5," ") exactly as is, and also using
Ctrl-Shift-Enter to confirm.

But it seems that, since you have entered it with a full path name, that it is
not in the same workbook as the data you are evaluating. *If that is the case,
perhaps the workbook is not being "found" in its new location.


The reason you see the full filename, is because when I select the fx
button, and look in user defined, I see my new UDF, and select it, and
Excel specifies the full filename. I've tried with and w/out this
filename. I'll put it back in Module1. The workbook itself is stored
on a sharepoint. I'll try storing it locally to see if it makes any
difference, but I'm afraid I'm grasping at straws here.

-Josh