adding quotations / brackets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Can you tell me how to add brackeets or quotations marks to a long list of
keywords?
 
One way to wrap it up ..

Assume source data running in A1 down

Wrap open & close brackets: "(" and ")"
In B1: =IF(TRIM(A1)="","","("&TRIM(A1)&")")
Copy B1 down to the last row of data in col A

Wrap double quotes: ""
In B1: =IF(TRIM(A1)="","",""""&TRIM(A1)&"""")
Copy B1 down to the last row of data in col A
 
You must log in or register to reply here.

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

When do I use quotation marks in an Excel formula? 2
SUMPRODUCT COUNTIF (Again) 3
Format single words in cells 3
Inability to add quotation mark around a variable by concatenation in VBA 4
Concatenating cells with ones that contain html tags and quotation marks? 1
vlookup lookup_value text 3
CELL return value without double quotation marks 1
Counting Cell with Quotation 4

Back
Top