Forum menu
Topic starter
I have two cells which I want to concatenate into one, but with a line break (i.e. as if I'd done Alt+Return when typing into the cell). Maybe an example would be clearer:
A1, value "Line 1"
A2, Value "Line 2"
I want A3 to be
"Line 1
Line 2"
I know [i]=A1&" "&A2[/i] will give me
"Line 1 Line 2"
Is there something like [i]=A1&"[b]excelmagickery[/b]"&A2[/i] that will put a line break in?
Posted : 11/11/2014 12:23 pm
=A1 & CHAR(10) & A2
Thou you'll have to turn on Wrap Text for that cell.
Posted : 11/11/2014 12:25 pm
You'll also need to format the cell with the formula in to wrap text.
RM.
Posted : 11/11/2014 12:27 pm
Topic starter
Is that just padding it out with blank space?
Posted : 11/11/2014 12:27 pm
Topic starter
Ah, old school line feed. Nice.
#EDIT# and thank you 😳
Posted : 11/11/2014 12:33 pm
Topic starter
On a similar note, is there a way I can do a find and replace, but the replacement bit being a line break?
Posted : 11/11/2014 12:45 pm