javajoe
Board Regular
- Joined
- Nov 7, 2005
- Messages
- 78
Hey folks -
I have a series of cells with text in them. I want to use CONCATENATE to consolidate them into one cell, but separate each with a Carriage return. Is there a formula way to do this?
I know about vbCrLf but I'm looking for a formula-based solution if possible.
What I have is =A1&CHAR(13)&A2 but that doesn't actually display the two lines of text on their own lines.
Any ideas?
I have a series of cells with text in them. I want to use CONCATENATE to consolidate them into one cell, but separate each with a Carriage return. Is there a formula way to do this?
I know about vbCrLf but I'm looking for a formula-based solution if possible.
What I have is =A1&CHAR(13)&A2 but that doesn't actually display the two lines of text on their own lines.
Any ideas?