CONCATENATE FUNCTION

[tadwestie]

Please I am so frustrated!! I have two columns of data, C and D In the
first column it is a url, and the second column a file url. I need to
combine the two into one column. This is for google base spreadsheet. I
used the formula
=CONCATENATE(C1,D1) AND NOTHING HAPPENED In some of the text I have read
you cannot do more than 250 strings at a time. There are 650 lines of data.
Is this my first mistake, do I need to put the line numbers in the formula.
Please help

 

[Ron Rosenfeld]

Please I am so frustrated!! I have two columns of data, C and D In the
first column it is a url, and the second column a file url. I need to
combine the two into one column. This is for google base spreadsheet. I
used the formula
=CONCATENATE(C1,D1) AND NOTHING HAPPENED In some of the text I have read
you cannot do more than 250 strings at a time. There are 650 lines of data.
Is this my first mistake, do I need to put the line numbers in the formula.
Please help

Where did you put your formula?
What do you mean by "nothing happened"?
Did the formula appear as text?
Did the formula return a blank?
etc.

Your formula should return a concatenation of the contents of C1 and D1.
What is actually in C1 and D1?
--ron

 

[Bernd P]

Hello,

Hmm, do you mean characters per cell?
Excel's limitations are (version dependent):
Excel 2.x: 255 char
Excel 3.0: 255 char
Excel 4.0: 255 char
Excel 5.0: 255 char
Excel 7.0/95: 255 char
Excel 97: 32'000 char
Excel 2000: 32'767 char
Excel 2002: 32'767 char
Excel 2003: 32'767 char
Excel 2007: 32'767 char
[citation from: http://www.xlam.ch/xlimits/]

If this does not help you, please clarify with an example and mention
your Excel version.

Regards,
Bernd

 

[Eduardo]

Hi,
try

=c1&b1

if you want to have an space use

=C1&" "&D1