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?

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?

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?