Assuming that the target column with the text values is A:
1) Create a new column with the following expression: = """" &A1 & """" at the first cell. Drag\Double click to fill the whole column.
2) Copy the values from this new column, and paste them Paste Special --> Values into a third column. Drag\Double click to fill the whole column.
3) You can now delete the original column A and replace it with the column in step (2)
1) Create a new column with the following expression: = """" &A1 & """" at the first cell. Drag\Double click to fill the whole column.
2) Copy the values from this new column, and paste them Paste Special --> Values into a third column. Drag\Double click to fill the whole column.
3) You can now delete the original column A and replace it with the column in step (2)
No comments:
Post a Comment