Hi Can you tell me how to add brackeets or quotations marks to a long list of keywords?
K kvedros Nov 6, 2006 #1 Hi Can you tell me how to add brackeets or quotations marks to a long list of keywords?
M Max Nov 6, 2006 #2 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
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
