It appears this formula is located in row 2 or higher on the original
spreadsheet. If you copy and paste this formula into row 1 of another
spreadsheet (or a row higher than the number of rows between 2 and the
row the formula is in), it will fail.

This is because the formula attempts to auto-adjust the row numbers (2
in this case) to something before row #1...as such, you will get a
formula that looks like this:

=CONCATENATE(#REF!," ",#REF!, " ",#REF!, " ",#REF!, ,#REF!," ",#REF!,
CHAR( 10),#REF!,CHAR(10),#REF!, " ",#REF!, CHAR( 10),#REF!, CHAR(
10),#REF!, " ",#REF!)

If I copy and paste your formula into row 2 or higher of my personal
spreadsheet, it works fine.

Note...use of CHAR(10) only works with concatenate if you have "Word
Wrap" enabled on the cell....just in case someone else is reading this
wondering why the CHAR(10) doesn't work on their machine :).


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=527828