I have a list of numbers in a column. I want to insert quotation marks
around the numbers. How do I do this without inserting them individually?
Thank you in advance for your help.

Here's the formatted text in BBCode:

Here's how you can insert quotation marks around the numbers in a column without doing it individually:

1. Select the column of numbers that you want to add quotation marks to.
2. Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
3. In the "Format Cells" dialog box, click on the "Custom" category.
4. In the "Type" field, enter the following format:
   Code:

   "0"

5. Click "OK" to apply the format to the selected cells.

If you want to copy and paste the formatted column to another location, you can use the "Paste Special" function to preserve the formatting. Here's how:

1. Copy the column of formatted cells.
2. Right-click on the cell where you want to paste the formatted column and choose "Paste Special" from the drop-down menu.
3. In the "Paste Special" dialog box, select "Values" and "Column Widths" (if desired).
4. Click "OK" to paste the formatted column.

=CONCATENATE("'",A1,"'")

Note there is a single quotation mark, ' , between the double quotation
marks in the formula I give above. If you want double quotation marks to
appear, then replace the single quotation mark with a double quotation mark.

Dave
--
Brevity is the soul of wit.


"Truc Lopez" wrote:

I have a list of numbers in a column. I want to insert quotation marks
around the numbers. How do I do this without inserting them individually?
Thank you in advance for your help.

or
=""""&A1&""""
or
=char(34)&a1&char(34)

(both work for double quotes)

Truc Lopez wrote:

I have a list of numbers in a column. I want to insert quotation marks
around the numbers. How do I do this without inserting them individually?
Thank you in advance for your help.

--

Dave Peterson

yet another way is the define a custom cell format (right
click-format cell-number-custom)

\"#,##0\";[Red]\"#,##0\"

which you can apply to a range of cells once defined.

the quotation mark cannot be entered directly into the custom format
field. you must insert it as a special symbol (0022) into a blank
field of your worksheet and then copy and paste that into your
definition. in case copy and paste gets flakey, once you have one
quotation mark in the format definition field, you can copy and paste
that one into the remainder of the formula rather than start over by
going back to the cell in the worksheet.

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thrttp://www.exceljockeys.com/forums/viewtopic.php?t=304536

I could pick up your formatting string and paste it directly into the Type box
on that custom format dialog.

Note to the original poster:

This doesn't actually change the value--it just changes the appearance in the
cell. (Not sure if that's important though.)

ExcelJockey wrote:

yet another way is the define a custom cell format (right
click-format cell-number-custom)

\"#,##0\";[Red]\"#,##0\"

which you can apply to a range of cells once defined.

the quotation mark cannot be entered directly into the custom format
field. you must insert it as a special symbol (0022) into a blank
field of your worksheet and then copy and paste that into your
definition. in case copy and paste gets flakey, once you have one
quotation mark in the format definition field, you can copy and paste
that one into the remainder of the formula rather than start over by
going back to the cell in the worksheet.

------------------------------------------------------------------------
ExcelJockey's profile: http://www.exceljockeys.com/forums/p...iewprofile&u=4
View this thrttp://www.exceljockeys.com/forums/viewtopic.php?t=304536

--

Dave Peterson