Hello.
1.Just write the double quotation in a empty cell.
2.In a column in front of your data enter a formula:
+<The first cell of your data range&<Cell where you wrote the double
quotation
3.Fix ($) the reference to the cell containing the double quotation.
4.Copy this cell until the end of your data.
5.Don't forget to transform you new data in Values.
Hope this helps
--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile:
http://www.excelforum.com/member.php...o&userid=35320
View this thread:
http://www.excelforum.com/showthread...hreadid=553224