Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatenate question on limitations
I'm trying to concatenate a list of "N" number of names. I'm aware of the 30
item limitation, but because of the N number of names, I thought I'd try something, Here's what I have: A B name 1 name 2 =concatenate(b1,b2,", ") name 3 =concatenate(b2,b3,", ") name 4 =concatenate(b3,b4,", ") etc, etc =concatenate(b(n-2),b(n-1),", ") name n =concatenate(b(n-1),bn,", ") and this works just fine. I've been able to concatenate up to 86 names successfully. What I ran into today baffles me. Today, I had 107 names. in the middle of the 87th name, it cut off and would not add any additional text. Example of the last several charachters... ~~~ Fred Smith, Joe Jones, Tom Sm The line above was repeated for all additional names in the list Where the last name displayed was Tom Smith, and other names followed. Fred Smith Joe Jones Tom Smith Fred Furrier etc etc My first thought was that I've run into some sort of text limitation. So I pasted the value of the last concatenation and got the length of it using the LEN function. The length was 1387. An awfully strange number to be a text limitation. Please don;t criticize the "inelegance" of my solution. I've had to adapt an existing computed list for a non-excel user to be able to copy and paste into a text document the final list of names and this seemed to be the simplest way to do it until I ran into this limitation. Any ideas what I've stumbled into? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenate Question | Excel Worksheet Functions | |||
Concatenate question | Excel Worksheet Functions | |||
CONCATENATE Question | Excel Discussion (Misc queries) | |||
Concatenate Question | Excel Worksheet Functions | |||
Concatenate question | Excel Worksheet Functions |