| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I bracket text in cells by formatting a whole column?
I want to bracket text or number in a cell, eg. abc becomes (abc). Or add
predetermined prefix to a number or text. How can I use the Text function or other Excel functions to get these kinds of formats? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I bracket text in cells by formatting a whole column?
With abc in A1
use this in B1 ="(" & A1 & ")" or =Concatenate("(",A1,")") -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "tywlam" wrote: I want to bracket text or number in a cell, eg. abc becomes (abc). Or add predetermined prefix to a number or text. How can I use the Text function or other Excel functions to get these kinds of formats? Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I bracket text in cells by formatting a whole column?
Another possibility: select the cell - Right-click / Select Format cells - select Number -Select Custom - In the format field enter "("####")" Ok Sheeloo;308336 Wrote: With abc in A1 use this in B1 ="(" & A1 & ")" or =Concatenate("(",A1,")") -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "tywlam" wrote: I want to bracket text or number in a cell, eg. abc becomes (abc). Or add predetermined prefix to a number or text. How can I use the Text function or other Excel functions to get these kinds of formats? Thanks -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86195 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I bracket text in cells by formatting a whole column?
"I want to bracket text or number in a cell"
Formatting will work only with numbers... "Pecoflyer" wrote: Another possibility: select the cell - Right-click / Select Format cells - select Number -Select Custom - In the format field enter "("####")" Ok Sheeloo;308336 Wrote: With abc in A1 use this in B1 ="(" & A1 & ")" or =Concatenate("(",A1,")") -- Pl click the YES button (if you see it - don''''''''t worry if you don''t), if this answer was helpful. "tywlam" wrote: I want to bracket text or number in a cell, eg. abc becomes (abc). Or add predetermined prefix to a number or text. How can I use the Text function or other Excel functions to get these kinds of formats? Thanks -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86195 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Display cells(text) in one column based on cells which are present inother column | Excel Discussion (Misc queries) | |||
| How to apply a bracket to right side of a series of text cells? | Excel Worksheet Functions | |||
| Formatting text column | Excel Discussion (Misc queries) | |||
| How do I bracket a column of numbers? | Excel Discussion (Misc queries) | |||
Linear Mode
