If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CONCATENATE FUNCTION
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 |
#2
|
|||
|
|||
CONCATENATE FUNCTION
On Mon, 11 Jan 2010 00:19:01 -0800, tadwestie
wrote: 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 |
#3
|
|||
|
|||
CONCATENATE FUNCTION
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 |
#4
|
|||
|
|||
CONCATENATE FUNCTION
Hi,
try =c1&b1 if you want to have an space use =C1&" "&D1 "tadwestie" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|