Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combining Multiple cells to 1 Address

Thread starter elsmith9035768
Start date Dec 16, 2018

E

elsmith9035768

Member

Dec 16, 2018

#1

See he Uploaded File for an example and my question. Thanks.

B

bosco_yip

Excel Ninja

Dec 16, 2018

#2

Maybe,

Added a Trim function in E5 formula,

=TRIM(E3&" "&F3&" "&G3&" "&H3)

Regards
Bosco

E

elsmith9035768

Member

Dec 17, 2018

#3

Good deal. Thanks!

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top