How do I add a " at the end of every cell text...

[NickTheBatMan]

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula =C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick

 

[GS]

NickTheBatMan formulated the question :

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula =C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick

Try...

=""""&C1&""&","&""&D1&""""

 

[Clif McIrvin]

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula =C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick

=""""&C1&", "&D1&""""

That's [ 4 ] (count'em!) double quotes at each end.

 

[GS]

Clif McIrvin wrote :

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula =C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick

=""""&C1&", "&D1&""""

That's [ 4 ] (count'em!) double quotes at each end.

Yeah, I didn't need the 2 occurances of &"", but was thinking of this
result:

"C1text","D1text"

by simply adding another pair of double quotes to each occurance. Also,
I forgot to include a space after the comma. Thanks for catching my
error!

 

[Clif McIrvin]

Clif McIrvin wrote :

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula
=C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick

=""""&C1&", "&D1&""""

That's [ 4 ] (count'em!) double quotes at each end.

Yeah, I didn't need the 2 occurances of &"", but was thinking of this
result:

"C1text","D1text"

by simply adding another pair of double quotes to each occurance.
Also, I forgot to include a space after the comma. Thanks for catching
my error!

don't give me too much credit! (Note the posting times of our
responses - we seem to have hit send about the same moment!)

 

[GS]

Clif McIrvin expressed precisely :

Clif McIrvin wrote :

I have 700 rows which I want to add a " at the beginning of column C
and the end of column D, but when I do =&"""C1 and =D1&""" Excel
complains
Oh yes, I'm then looking to combine them so I have the formula =C1&",
"&D1 so I'll end up with "text, text" in E...

I hope it's going to be something very simple and that I'm not going
to have to do it manually ?!

TIA

Nick


=""""&C1&", "&D1&""""

That's [ 4 ] (count'em!) double quotes at each end.

Yeah, I didn't need the 2 occurances of &"", but was thinking of this
result:

"C1text","D1text"

by simply adding another pair of double quotes to each occurance. Also, I
forgot to include a space after the comma. Thanks for catching my error!

don't give me too much credit! (Note the posting times of our responses - we
seem to have hit send about the same moment!)

Well then, that suggests you're sharper today than I am. (I'm fighting
a nasty head cold and so a bit slow<g>)

 

[Clif McIrvin]

Clif McIrvin expressed precisely : [ ]
Well then, that suggests you're sharper today than I am. (I'm fighting
a nasty head cold and so a bit slow<g>)

I'm sure that ('sharper') comes and goes <grin>

bummer on the cold

 

[Dave Peterson]

Sometimes, when I have trouble with all those " strings, I'll use =char(34) to
represent the double quote:

=char(34)&...&char(34)