0
What is the maximum number of text items that you can join into a single text item using the concatenate functions?
Wiki User
∙ 7y ago
If you used the CONCATENATE function then there's a limit to the number of arguments which is Excel version dependent. Excel 2007 and newer versions allow 255 arguments, all older versions allow 30 arguments. You don't need to use the CONCATENATE function. You can use the & operator
to concatenate instead.
=A1&", "&B1&", "&C1
Using this method you're only limited by the allowable maximum length for a formula which, again, is version dependent. Excel 2007 and newer versions allow 8192 characters, all older versions allow 1024 characters. You could also concatenate the results of several concatenate formulas in a new formula.
Wiki User
∙ 6y ago
Wiki User
∙ 7y agoYou can have up to 255 items, up to a total of 8,192 characters.
Add your answer:
Earn +20 pts
What is the maximum number of text items you can join into a single text item using concatenate function?
You can have up to 255 items, up to a total of 8,192 characters.
What is the maximum number of text items that you can join into a single text item using the concatenate function?
You can have up to 255 items, up to a total of 8,192 characters.
What is the range Mode median maximum and minimum of 3335728291215 1130?
The range of a single number is 0.The mode, median, maximum and minimum of a single number is the number.
How do you concatenate picture files into a single picture file?
you have to double it over as many times as necessary
What is the maximum number of electrons that can occupy one orbit?
2 electrons is the maximum number for an single orbital.
What is the maximum of electrons that can occupy one orbital?
2 electrons is the maximum number for an single orbital.
What are the maximum number of cells you can merge?
There is no limit to the number of cells you can merge into a single cell.
What is the maximum number of partitions supported by a single dynamic disk?
4
What is the maximum number of devices that can be connected to a single USB interface?
48
Who won ladies single Wimbledon title maximum number of times?
g
What is the maximum number of electrons that a single orbital can hold?
2
What is the maximum number of channels that a single T1 can contain?
544,638,374,283,290,000,000,000,000,000,000. te he!
