insert text at the beginning and enclose the values of one column in excel to another

0

The problem I have is given a column1 to pass the [dynamic] data to column2 with the following conditions:

a) quote with quotation marks each data from column1 to the column2 and that the first data is added to the parenthesis at the beginning left and the last data is added to the end of the last data right parentheses and have the data copied to the clipboard
example

columna1 resultado de la columna2 

a                       ('a'
b                        'b'
c                        'c') 

b) The second case is similar, but at the beginning of column 2 it should be add a text x according to three criteria which makes a loop example

columna1 resultado de la columna2
                           text1
a                         ('a'
b                          'b'
c                           c)    

                          text2
a                         ('a'
b                          'b'
c                           c)    

                         text2
                          ('a'
                           'b'
                            c)    

                          text3
                          ('a'
                           'b'
                            c)    
    
asked by joed 05.04.2017 в 22:42
source

2 answers

0

Try this way:

="('"&A1&"''"&A2&"''"&A3&"')"

Obviously that depends on the position of the cells.

Greetings.

    
answered by 05.04.2017 в 23:06
0

With regard to the first case, in my opinion the correct way to handle this would be through conditional

For the second case you can use the same method, I can not help you anymore without knowing what types of criteria you would use to assign or not the text

I add the formula: = IF (E5="", "('" & E6 & ";" ", IF (E7=" ","' "& E6 &" ') ","' "& E6 & "'")))

    
answered by 12.04.2017 в 05:04