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

P

Pete_UK

Like this:

=A1&")"

if your data is in A1. Copy down as required.

Hope this helps.

Pete
 
R

Rick Rothstein \(MVP - VB\)

If you mean to the cell the entry is in, you can Custom Format the cells
using these 3 characters as the pattern...

@\]

Rick
 
G

Gord Dibben

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
 

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

How to remove a bracket that is itallicised for an entire document 1
Select Text to End of Footnote 9
Corrupt? Scrolling while viewing two pages side by side, pages go wonky? 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to print an A4 document to 2 A5s 0
Continues to move to the right 0
How do I bracket text in cells by formatting a whole column? 3

Top