Excel: A Painfull String operation taking ages to complete - Please help

Hi Forum - Salutations to the excel masters, MVPs. Looking to seek your help with something giving me pain from a long time. Very often I need to append apostrophe (') character to a column containing 700,000+ rows. So i have written this simple macro to do the job. But the problem is it takes lot of time (2-5 minutes). Therefore I wanted to get your opinion if there is an efficient and faster way to do this. Maybe instead of cell by cell operation, is there a way to do a range operation - Range = "'" & Range & "'". Sub AddApostrophie() Dim cell As Range For Each cell In Selection cell.Value = "''" & cell.Text & "'" Next cell End Sub

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of November 23, 2015.

For more resources for Microsoft Excel