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 do I bracket text in cells by formatting a whole column? 2
Xbox Series X (£449) and Series S (£249) 6
Access Counting records based on multiple age bracket and output to tabulated report 0
Series fill only copying and fill series greyed out 1
Multiple line, one bracket [ ] 2
Right align positive and neg numbers using brackets around neg #s 1
Xbox Series X anomaly (sort of) 4
Convert multiple series into single series 0

Top