I would like to add parentheses ( ) around certain text within cells. How can I do this?

If you wish the results to be used in another cell, than this can be done using a formula:

= "(" & cellref & ")"

where cellref is the cell where the desired text is located (e.g., B3).

A custom format can also be applied directly to a cell which can display the content in parentheses:

  1. With the desired cell selected, click "Format - Cells"
  2. On the "Number" tab, select the category: "Custom"
  3. For the Type, enter: (@)
  4. Click OK.

(see Conditional Formatting at Excel Tutorials)

Tags: excel
Last update:
2007-07-26 14:16
Ask MIStupid
Average rating: 3.07 (69 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.