hi,

I have a similar question.

I have concatenated several lines of text, but I want to make it neater by entering a line break in between certain lines.

I currently have 3 cells with the text and between them I want a line break. I need to keep the concatenate formula I'm using because it will change weekly.

I have tried entering alt-enter but it doesn't alter the text- is there anyway I can concatenate a ^p into the formula?

Currently is Text1, Text2, Text3

I want it to be:
text 1
text 2
text 3

As the size of text differs I am unable to wrap text and format the width of column and do it manually.

Any help much appreciated.

You shouldn't post questions of your own in someone else's thread. This isn't as related as it appears.

Anyway, format the cell to allow WRAP TEXT, then use a formula like this to force line feeds:

=A1&CHAR(10)&B1&CHAR(10)&C1

Please present the formula from that collection you are advertising that directly relates to this question.

If one does not exist, this is spamming. Cut it out.