Tag: CONCATENATE

To add a newline or a hard return in front of certain text, we try the Find & Replace option, but ends up nowhere. Instead make use of the CHAR(10), MS has provided, in your formulaes. Usage: =CONCATENATE("Heading1",CHAR(10),"Content under Heading1")   Let me take a complex example also, to get you the feel of the ...