Results 1 to 4 of 4

Thread: How can I Add brackets automatically in every cell in Microsoft Excel

  1. #1
    Join Date
    Jan 2012
    Posts
    15

    How can I Add brackets automatically in every cell in Microsoft Excel

    I have a column in Excel that I want to enclose the contents with brackets in every cell. Is there an easy way to do that? Thanks

  2. #2
    Join Date
    Jul 2011
    Posts
    640

    Re: How can I Add brackets automatically in every cell in Microsoft Excel

    Insert a column tothe left (assuming stuff is in A). In B1 ="("&A1&")". Copy down column. Select all of B; Copy followed by Edit|Paste Special -> Values. Now you can delete column A.

  3. #3
    Join Date
    Jul 2011
    Posts
    634

    Re: How can I Add brackets automatically in every cell in Microsoft Excel

    If you just want the brackets to appear you can use Format - Cells - Number - Custom: "["General"]";"["General"]";"["General"]";"["@"]". Paste it in from this post. If you have numbers that require specific number formatting, replace the word General with any number format you want. The first is for positive numbers, then negative, then zero. The last part, "["@"]" , is for text. If you want to actually put the brackets into the cells, it will require a formula in another cell, which could be pasted back over the original stuff to make the brackets permanent in your original cells. The formula used depends on what you have in the cells, numbers or text. If any of the original cells are formulas, they'll have to be modified to include the brackets; don't use this method, though you can use the first.

  4. #4
    Join Date
    Jul 2011
    Posts
    623

    Re: How can I Add brackets automatically in every cell in Microsoft Excel

    You could enter the following formula in the column next to it ="(" & A1 &")". Alternatively you could select the cells and run the macro given below :
    Code:
    Sub Test()
    Dim cell As Range
    For Each cell In Selection
    cell.Value = "(" & cell.Value & ")"
    Next cell
    End Sub

Similar Threads

  1. Replies: 1
    Last Post: 10-04-2012, 11:16 PM
  2. Want help to filter merge cell in Microsoft Excel
    By DEvOTeEL in forum MS Office Support
    Replies: 2
    Last Post: 24-02-2012, 07:00 PM
  3. Replies: 2
    Last Post: 23-02-2012, 07:23 PM
  4. Replies: 2
    Last Post: 23-02-2012, 02:54 PM
  5. How to delete first 4 letters of Cell in Microsoft Excel
    By Ulrich in forum MS Office Support
    Replies: 2
    Last Post: 18-01-2012, 06:51 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,690,660.91293 seconds with 17 queries