Column A in my Excel sheet contains phrases (there are about 75 filled cells in that column). I need to place double quotes around each phrase in each cell in that column. Is there a formula I can use? How?
2007-11-17 07:14:37 · 3 answers · asked by Anonymous in Business & Finance ➔ Other - Business & Finance
You could create a macro. I was researching it, but I don't have time and you may have an older version of Excel than I do.
Anyway, a macro could do it nicely.
2007-11-17 08:04:18 · answer #1 · answered by hottotrot1_usa 7 · 0⤊ 1⤋
In an adjacent column, you can have this formula (e.g. at row 2):
="""" & A2 & """"
There are 4 double quotes before and after the A2.
Copy this and paste it (or drag it down to autofill) as far down as you have data in column A.
If you need more info, edit your question to add more details, or e-mail.
Good luck.
.
2007-11-17 23:30:09 · answer #2 · answered by aladou 5 · 1⤊ 0⤋
Highlight the cell(s) you wish to type your phrase in, click the Format icon in the toolbar, then click Cells, then choose the Number tab, then click Text from the drop-down menu, and close the box by clicking OK. After this, you can type any text you like in the chosen cell(s).
2007-11-18 00:14:39 · answer #3 · answered by Sandy 7 · 0⤊ 1⤋