=CONCATENATE(X1,X2,X3)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Marc Hebert" <Marc wrote in message
...
I'm trying to construct a formula to concat text in a range of cells
without
listing the cells individually in a comma-separated list, so that the
formula
automatically takes into account newly inserted cells. concatenate(x1:x3)
results in a #VALUE error.

Any advice?

Thanks,
Marc