Concatenate and Substitute

Using some code to consolidate an address to also include <br> HTML tags

First Name – A2

Last Name – B2

Address1 – C2

Address2 – D2

Address3 – E2

=CONCATENATE(A2,” “,B2,”<br>”,(SUBSTITUTE(TRIM(C2 & ” ” & D2 & ” ” &E2), ” “, “<br> “)))

Results

Joe Smith<br>1<br> 2ndstreet