Computers » Excel
ID #1022
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:
- With the desired cell selected, click "Format - Cells"
- On the "Number" tab, select the category: "Custom"
- For the Type, enter: (@)
- Click OK.
(see Conditional Formatting at Excel Tutorials)
Tags: excel
Related entries:
- I have a very very large spreadsheet which has a column formatted as follows: B 101.1.1. I need to delete the B and leave the numeric. How can I do this without deleting the B row by row?
- What date is 90 days from August 10, 2007?
- Is there a world record for text messages in a month?
- When I type in text in an Excel worksheet it tries to help by filling in the rest of the cell if the characters are similar to an existing cell. This is not helping me enter data at all. How can I turn this feature off?
- What is the volume in yards, of a cone-shaped pile with a 90-foot base circumference and 15-feet tall?
Last update: 2007-07-26 14:16
Author: Ask MIStupid
Revision: 1.0
Print Page
You cannot comment on this entry
|
