Combine text from two or more cells into one cell

Occasional Contributor

Hello,

 

I need a formula in Cell: B4.

 

The formula will add the text in Cell: B1, B2, B3.

 

Thanks in advance.

2 Replies

@Oliullah THat could be as easy as:

=B1&" "&B2&" "&B3

 

Thanks a lot