Excel - Adding double quotes around entries in a column

Asked By NCdesigne on 12-Dec-08 08:29 AM
I need to add double quotes at the beginning and end of all entries in a very
long column. How can I do this without typing manually?
--
NC designer




Eduard replied on 12-Dec-08 08:37 AM
Hi,
Let's say the column is A, in B enter this formula
=""" &A1& """
if this was helpful click yes
Jarek Kujawa replied on 13-Dec-08 07:14 PM
=CHAR(34)&A1&CHAR(34)

then copy and paste as values
Jarek Kujawa replied on 13-Dec-08 07:14 PM
or

=""""&A1&""""

each " 4 times
Bernard Liengme replied on 12-Dec-08 09:09 AM
In next column, use formula =""""&A1&""""  and copy it down the column by
double clicking the fill handle (small sold square in lower right corner of
active cell)

If you wish you could select and copy all of the results; then with the
range still selected use Edit | Paste Special with Values specified. This
converts formulas to values and allows you to delete the original data
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
David Biddulph replied on 12-Dec-08 09:22 AM
You might want to test that, Eduardo?
--
David Biddulph
Gord Dibben replied on 12-Dec-08 03:34 PM
If you want minimal typing and no formulas to clean up....................

Sub Add_Text_Left_Right()
Dim Cell As Range
Dim moretext As String
Dim thisrng As Range
On Error GoTo endit
Set thisrng = Range(ActiveCell.Address & "," & Selection.Address) _
.SpecialCells(xlCellTypeConstants, xlTextValues)
moretext = InputBox("Enter your Text")
For Each Cell In thisrng
Cell.Value = moretext & Cell.Value & moretext
Next
Exit Sub
endit:
MsgBox "only formulas or numbers in range"
End Sub

Select the column.....................Enter " in the Inputbox.


Gord Dibben  MS Excel MVP


On Fri, 12 Dec 2008 05:29:00 -0800, NCdesigner