<div>
Thank you for the prompt responses and for the added explanations. &nbsp;You guys are terrific!<br />
<br />
Gary<br />
Cincinnati
</div>


Thank you for the prompt responses and for the added explanations.  You guys are terrific!

Gary
Cincinnati

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I want a formula to concatenate Name and Email fields to create a Full Email address. &nbsp;The concatenate formula doesn't like starting with a quotation mark. &nbsp;See e.g. below.<br />
<br />
Name: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Gary Robbins<br />
Email &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;garyrobbins@fuse.net<br />
Full Email &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[formula] &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;Gary Robbins&quot; &lt;garyrobbins@fuse.net&gt;<br />
<br />
Gary
</div>
</div>


Hello Experts,

I want a formula to concatenate Name and Email fields to create a Full Email address.  The concatenate formula doesn't like starting with a quotation mark.  See e.g. below.

Name:		Gary Robbins
Email		garyrobbins@fuse.net
Full Email 	[formula]	"Gary Robbins" <garyrobbins@fuse.net>

Gary

Concatenate Full Email Address

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.