J.E. McGimpsey has a User defined function that will concatenate cells.

You can find it at:
http://www.mcgimpsey.com/excel/udfs/multicat.html

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

sierra wrote:

How to combine text from many cells without writing each cell adress,
just the scope of cells?
Can I combine tex from cells A1 to A3 in a faster way than writing a
formula: '=A1&" "&A2&" "&A3' ? I need to find a way to combine text
from a really huge number of cells, like from B1 to B3489, and I want
to do it without writing every cell adress.

--
sierra
------------------------------------------------------------------------
sierra's Profile: http://www.excelforum.com/member.php...o&userid=25099
View this thread: http://www.excelforum.com/showthread...hreadid=386088

--

Dave Peterson