I have some cells containing text and I want to concat them together using an option-return character. None of the functions appear to let me use anything other than the standard alphanumerics. For example, to go from 3 separate cells:
cell 1: very long text
cell 2: short text
cell 3: very much longer text
to one combined cell
cell 4: very much longer text
very long text
short text
Does this do what you want:
RThe option-return characters are enclosed in pairs of quotation marks to identify them to the formula as 'TEXT' characters.
My entry process for this formula in cell B2 was this:
Regards,
Barry
Does this do what you want:
RThe option-return characters are enclosed in pairs of quotation marks to identify them to the formula as 'TEXT' characters.
My entry process for this formula in cell B2 was this:
Regards,
Barry
Another way would be to use CHAR(8232) to create the line separator character.
=CONCAT("abc",CHAR(8232),"def")
or
="abc"&CHAR(8232)&"def"
That is great, thanks! Using the shift-option-return worked. I expanded this by putting the shift-option-return in a cell and then was able to use TEXTJOIN to reference it plus the cell range carrying the text items to do the transformation.
Very nice, I didn't know about the codes up that high. Thanks.
combine cells with option-return character
