How to apply a bracket to right side of a series of text cells?

  • Thread starter Thread starter Leeve it to Me
  • Start date Start date
L

Leeve it to Me

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
 
If you mean to the cell the entry is in, you can Custom Format the cells
using these 3 characters as the pattern...

@\]

Rick
 
In a helper column enter =cellref & "]"

Drag/copy down.

When happy, copy and paste special>values>ok>esc

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Xbox Series X (£449) and Series S (£249) 6
Access Invalid bracketing of parameter name 1
How do I bracket text in cells by formatting a whole column? 2
Curly Brackets 2
Series fill only copying and fill series greyed out 1
percentage in brackets 2
Xbox Series X anomaly (sort of) 4
Right align positive and neg numbers using brackets around neg #s 1

Back
Top