How to put Brackets covering two or more cells in Excel

N

No

I am taking about
using Square and curve Curve & round Brackets
Here I can not merge cells due to various reasons.

Excel 2003
 
S

Sandy Mann

No said:
Here I can not merge cells due to various reasons.
Click to expand...

Sounds like a good idea to me!

You don't explain what it is that you are trying to do but just guessing:

="(" & SUM(D1:D18)&" How to put Brackets covering two or more cells in Excel
" & SUM(B1:B18)&" )"

Then select the range of cells that you want the formula to appear in and
select:
Format > Cells > Alignment > Horizontal > Center Across Selection

Unlike merging cells, Center Across Selection will still let you select
columns.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top