is it possible to combine data from more than 2 cells without losing the data
from the cells? i know i can concatenate 2 cells, but what about data from 3
or more cells?

Hi,

=A1&B1&C1&D1

Mike


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"adkmayhem" wrote:

is it possible to combine data from more than 2 cells without losing the data
from the cells? i know i can concatenate 2 cells, but what about data from 3
or more cells?

Just to let you know, CONCATENATE function takes 255 arguments.

CONCATENATE (text1,text2,...)

Text1, text2, ... are 2 to 255 text items to be joined into a single text item. The text items can be text strings, numbers, or single-cell references.

all the best