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

  • Thread starter Thread starter NickTheBatMan
  • Start date Start date
N

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
 
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
Click to expand...

Try...

=""""&C1&""&","&""&D1&""""
 
NickTheBatMan said:
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
Click to expand...


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

That's [ 4 ] (count'em!) double quotes at each end.
 
Clif McIrvin wrote :
NickTheBatMan said:
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
Click to expand...


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

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

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!
 
GS said:
Clif McIrvin wrote :
NickTheBatMan said:
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
Click to expand...


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

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

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!
Click to expand...


don't give me too much credit! (Note the posting times of our
responses - we seem to have hit send about the same moment!)
 
Clif McIrvin expressed precisely :
GS said:
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.
Click to expand...

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!
Click to expand...


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

Well then, that suggests you're sharper today than I am. (I'm fighting
a nasty head cold and so a bit slow<g>)
 
GS said:
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>)
Click to expand...


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

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

=char(34)&...&char(34)
 
Back
Top