Combing text boxes for contact details database

[mrcquick]

Hi, I was wondering if you could help me. I’ve been given a contacts database where business name, manager name and address are in separate columns. Is there a formula I can use to join these together like the green box in the image above where it’s set out like an address

[#2]

@mrcquick Sorry this is the image that should have uploaded

[#3]

@mrcquick See which works best for you. Not that you must have "wrap text" active in the cell where you use the linefeeds, i.e. CHAR(10)

A third option would be to use CONCATENATE, similar to CONCAT, if you have an older Excel version.