You can use this formula for your first string. Use accordinlgy for last
string.

=CONCATENATE("""","(","'",E7,"'",",")

"Mo2" wrote:

this is what one line looks like, for example:

Boom 5 bling 4 ding 3

i want to apply a cell format that would make the cells look like this:

"('Boom', '5', 'bling', '4', 'ding', '3')"


as you can see, the first cell has a double quote and a paranthese.
and the last cell has a closing paranthese and a doublequote.

the rest are wrapped in single quotes followed by a comma.

i've figured out the cell format for all the cells, except the first and
last one.
how would I specify the cell format for the first cell and the last cell?
(its not working for me)

oh, and 2nd question:

Sometimes, the cells with TEXT values in willl sometimes have the NUMBER 0
in them (if a condition is false or what not.)

The 0 wont have the same format applied becuz it is a NUMBER in a text
formatted cell.
. how would i also apply a number cell format? or treat the number as text?

(perhaps a conditional format would help...i just dont know how to write it)

thanks in advance, if you can help with either question