Hello,

Could some one please help me with the following?

In column B of my workbook, I have a list of text data (5500 lines) - an
example of this is given below. I wish to prefix each data value with a
single quotation mark as shown below, but I do not know how to do this.

Cell B2: ABC123-UYT
Cell B3: 001HF-367
Cell B4: 00001-KML-8741

I need to change the above to this:

Cell B2: 'ABC123-UYT
Cell B3: '001HF-367
Cell B4: '00001-KML-8741


Any help would be greatly appreciated.

Thanks,

Chris.




*** Sent via Developersdex http://www.developersdex.com ***