Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
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?
=A1 & CHAR(10) & A2
Thou you'll have to turn on Wrap Text for that cell.
You'll also need to format the cell with the formula in to wrap text.
RM.
Is that just padding it out with blank space?
Ah, old school line feed. Nice.
#EDIT# and thank you 😳
On a similar note, is there a way I can do a find and replace, but the replacement bit being a line break?