View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default How to put Brackets covering two or more cells in Excel

No" <No @discussions.microsoft.com wrote in message
...
Here I can not merge cells due to various reasons.


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


Replace @mailinator.com with @tiscali.co.uk


"No" <No @discussions.microsoft.com wrote in message
...
I am taking about
using Square and curve Curve & round Brackets
Here I can not merge cells due to various reasons.

Excel 2003