How to apply a bracket to right side of a series of text cells?
How to apply a bracket to right side of a series of text cells?
|
How to apply a bracket to right side of a series of text cells?
Like this:
=A1&")" if your data is in A1. Copy down as required. Hope this helps. Pete On Jan 4, 7:15*pm, Leeve it to Me <Leeve it to wrote: How to apply a bracket to *right side of a series of text cells? |
How to apply a bracket to right side of a series of text cells?
If you mean to the cell the entry is in, you can Custom Format the cells
using these 3 characters as the pattern... @\] Rick "Leeve it to Me" <Leeve it to wrote in message ... How to apply a bracket to right side of a series of text cells? |
How to apply a bracket to right side of a series of text cells?
In a helper column enter =cellref & "]"
Drag/copy down. When happy, copy and paste specialvaluesokesc Delete original column or paste helper column over orignal and delete helper. Gord Dibben MS Excel MVP On Fri, 4 Jan 2008 11:15:04 -0800, Leeve it to Me <Leeve it to wrote: How to apply a bracket to right side of a series of text cells? |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com