Concatenate text cells fails.

[Jim Buttery]

Merge two text cells in Excel 2000 uses cell names not
values. Both source and dest. are formatted as text.

 

[Peo Sjoblom]

That's the problem, format as General and not text